Amsterdam, NLDynamic Pareto analysis in Power BI
Marco Russo & Alberto FerrariThis article describes how to implement a dynamic Pareto calculation in Power BI based on a measure that can be selected from a slicer and dynamically filtered by other slicers in the report. Read more
Filtering weekdays in DAX
When using time intelligence functions, the automatic REMOVEFILTERS on Date can make maintaining filters on the Date table challenging. This article shows a technique to handle filter-preserving columns in DAX. Read more
May 28-30 - Chicago
Aug 19-21 - Toronto
Video Training
Introducing DAX Video CourseFree
DAX and semantic models announcements at the Fabric Conference 2025
Marco RussoI usually do not write about announcements and new features until we have had time to try and test them in the real world. However, there are always exceptions, and some of the announcements at the Microsoft Fabric Conference 2025… Read more
Using AI assistance to create Power BI custom visuals
Kurt BuhlerThis article is about a process to use AI tools like LLMs to create custom visuals in Power BI, and how this still requires deliberate thought, planning, and learning. 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