Best practices for using KEEPFILTERS in DAX
This article describes the best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. Read more
This article describes the best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. Read more
We are proud to announce the availability of our new book, Optimizing DAX. Read more
This article describes how to compare time series that occur in different periods by standardizing the timelines to days since a specific event. Read more
Digital media content creators have an ethical responsibility to journalistic integrity. All of them do; all of us… including myself. Read more
Parent-child hierarchies are often used to represent charts of accounts stores salespersons and such Parent-child hierarchies have a peculiar way of storing the hierarchy in the sense that they have a variable depth In this pattern we show how to… 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