The Optimizing DAX book is available
We are proud to announce the availability of our new book, Optimizing DAX. 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
Almost a year ago, we announced the release of three sections (core concepts, formula engine, and VertiPaq); in November 2023, we released the DirectQuery over SQL section; now, in April 2024, we release the last section of Optimizing DAX about… Read more
The static segmentation pattern classifies numerical values into ranges A typical example is the analysis of sales by price range You do not want to slice the data by individual price instead you want to simplify the analysis by grouping… 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