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
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.
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
11:30#articleMarco Russo
VAR.P, VAR.S, VARX.P, VARX.S
01:59#daxguideAlberto Ferrari
ISERROR
02:26#daxguideAlberto Ferrari
STDEV.P, STDEV.S, STDEVX.P, STDEVX.S
02:07#daxguideAlberto Ferrari
ISEVEN, ISODD
00:40#daxguideAlberto Ferrari