Differences between ALL and ALLCROSSFILTERED
This article describes the differences between the ALL and CROSSFILTERED functions in DAX. Read more
This article describes the differences between the ALL and CROSSFILTERED functions in DAX. Read more
This article describes how to optimize inventory calculations in DAX by using snapshots to avoid the computational cost of a complete running total. Read more
After another year, it is time to recap what happened in the DAX and SQLBI worlds and provide a few spoilers about 2025! Read more
This article is about how you can save time when building and maintaining Power BI reports by using strategies to re-use visual formatting. Read more
In this pattern we show you how to compute time-related calculations like year-to-date same period last year and percentage growth using a standard calendar The great advantage of working with a standard calendar is that you can rely on several… More on DAX Patterns
Optimizing DAX is the state-of-the-art book on optimizing DAX expressions in Power BI and Analysis Services semantic models.
Learn how to locate performance bottlenecks, read the query plan and performance metrics, rewrite the slower part of an expression, and measure the performance improvements. Read more