Amsterdam, NLOptimizing incremental inventory calculations in DAX
Marco Russo & Alberto FerrariThis article describes how to optimize inventory calculations in DAX by using snapshots to avoid the computational cost of a complete running total. Read more
What happened in the DAX world in 2024
Marco RussoAfter another year, it is time to recap what happened in the DAX and SQLBI worlds and provide a few spoilers about 2025! Read more
Feb 18-20 - Phoenix
Video Training
Introducing DAX Video CourseFree
Re-using visual formatting in and across Power BI reports
Kurt BuhlerThis 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
SQLBI+ updates in December 2024
We released more content in SQLBI+ with two new sessions: Introducing Visual Calculations in Power BI: This two-hour session introduces the Visual Calculations feature in Power BI, which is still in preview. We plan to update the “Understanding Visual Calculations… Read more
DAX Patterns
Parent-child hierarchies
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
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