Chicago, IL, USThe Optimizing DAX book is available
Marco Russo & Alberto FerrariWe are proud to announce the availability of our new book, Optimizing DAX. Read more
Comparing cumulative values for events in different periods
Kurt BuhlerThis article describes how to compare time series that occur in different periods by standardizing the timelines to days since a specific event. Read more
May 27 - Amsterdam
Aug 9 - Melbourne
Sep 23-25 - Vancouver
May 14-16 - Hamburg
Video Training
Introducing DAX Video CourseFree
Author’s responsibility
Marco RussoDigital media content creators have an ethical responsibility to journalistic integrity. All of them do; all of us… including myself. Read more
The second edition of Optimizing DAX is complete
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
DAX Patterns
Standard time-related calculations
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
SQLBI Corp.
Optimizing DAX, Second Edition
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