SQLBI Newsletter #223

NEW ARTICLE

Computing sales to specific customers before and after a time period

This article shows how to manipulate the filter context to create a report with the sales made to a specific customer segment, before and after a selected month.
Read more

NEW POST

Different filter behaviors in SUMMARIZECOLUMNS and CALCULATETABLE

This blog post includes an example that clarifies the difference between a filter applied to SUMMARIZECOLUMNS and a filter applied to CALCULATETABLE.
Read more

#223 · Aug 2022

LEARNING

Course calendar

Mastering DAX

	Aug 29-31 - Munich
	Sep 28-30 - Brisbane
	Oct 4-6 - Melbourne
	Oct 4-6 - Amsterdam
	Oct 10-12 - Sydney
	Nov 9-11 - Chicago

Data modeling

	Nov 9-11 - Chicago
	Dec 5-7 - Amsterdam

video courses

	Mastering Tabular
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	DAX Tools
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	Power Pivot

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI August 2022 updates This monthly release introduces a few minor reporting features and is mostly about bug fixes. Unfortunately, the most important one (a set of improvements to the IntelliSense suggestions provided by the DAX formula bar) introduced a new bug that breaks the automatic code indentation. It happens. Will we see a quick fix in the next few days? We hope so. Aug 9, 2022 · Microsoft
	• On-premises data gateway July 2022 update Sooner or later, we will not need these monthly updates. By now, we are still in the manual update world. Aug 1, 2022 · Microsoft
	• A Power BI gateway monitoring & troubleshooting solution If you have a cluster of data gateways, you may want to monitor them. A Power BI template can help you do that without too much effort. Jun 26, 2022 · Rui Romano
	• Custom queries for “Detect Data Changes” in Power BI incremental refresh A complete example that describes how to implement the “detect data changes” feature in Power BI, getting direct control over what data is refreshed during an incremental refresh. Jul 31, 2022 · Chris Webb
	• Calling the Power BI enhanced refresh API from Power Automate Another way to control the dataset refresh is to use a specific REST API with Power Automate. No code involved, just a little bit of JSON configuration. Aug 7, 2022 · Chris Webb
	• Tabular Editor 2.17.0 The free version of Tabular Editor continues to get bug fixes and other upgrades. This version supports additional features in the Tabular model and settings sent through group policies. Aug 11, 2022 · Daniel Otykier
	• Analysis Services server properties in Power BI Premium It is finally possible to set several Analysis Services server properties in Power BI Premium at the workspace level. Settings like DefaultSegmentRowCount and MaxIntermediateRowsetSize are vital for certain business scenario. The bad news is that this feature is available only for Premium Capacity and not Premium per User. Aug 2, 2022 · Microsoft

SQLBI YOUTUBE CHANNEL