SQLBI Newsletter #213

NEW ARTICLE - DAX 101

Understanding the difference between a row context and a filter context is the first and most important concept to learn to use DAX correctly. This article introduces the row context, and is part of a series of articles about evaluation contexts in DAX.
Read more

DAX PATTERNS

Like-for-like comparison

The like-for-like sales comparison is an adjusted metric that compares two time periods, restricting the comparison to products or stores with the same characteristics.

#213 · Mar 2022

LEARNING

Course calendar

Mastering DAX

	Mar 29-31 - Charlotte
	Apr 4-6 - Chicago
	May 18-20 - Copenhagen
	May 23-25 - Amsterdam
	Jun 21-23 - Seattle
	Oct 11-13 - Melbourne
	Oct 17-19 - Sydney

Data modeling

	May 23-25 - New York
	Oct 5-7 - Sydney

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

For example, the like-for-like comparison only evaluates those stores that were open in all the periods considered, ignoring stores that opened or closed within the periods analyzed.
Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI March 2022 updates The March 2022 release of Power BI comes with many small updates and enhancements. A very important one is the support for dynamic format strings for all chart elements. This means you can use the calculation groups without breaking the display format in native visuals. Custom visuals can implement a new API now, but you must wait for a new version of the custom visuals you use. Mar 17, 2022 · Microsoft
	• The ExtAuth trace event in Power BI A new trace event in Power BI Premium is helpful to track performance issues caused by authentication for models that are not available in memory. Mar 13, 2022 · Chris Webb
	• Query Folding in Power Query (part II) This is the second article of a series dedicated to query folding in Power Query. Suggested reading if you want to understand how query folding works and how to control it. Mar 21, 2022 · Ben Gribaudo

SQLBI YOUTUBE CHANNEL

Latest videos

How to return BLANK instead of zero