Amsterdam, NLFiltering weekdays in DAX
Marco Russo & Alberto FerrariWhen 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
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
May 28-30 - Chicago
Aug 19-21 - Toronto
Video Training
Introducing DAX Video CourseFree
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
Using visual calculations for conditional formatting
Visual calculations are useful for performing calculations specific to a visual. Conditional formatting is a great example of this concept. In this article, we show how to easily implement conditional formatting through visual calculations. Read more
DAX Patterns
Custom time-related calculations
This pattern shows how to compute time-related calculations like year-to-date same period last year and percentage growth using a custom calendar This pattern does not rely on DAX built-in time intelligence functions All the measures refer to the fiscal calendar… 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