Amsterdam, NLBlank in date columns and DAX time intelligence functions
Marco Russo & Alberto FerrariThis article explores the implications of having blank values in date columns and provides the best practices for managing them in DAX calculations and Power BI reports. Read more
What we are working on at SQLBI
Marco RussoNo, this is not the end-of-the-year blog post about what happened in 2024: There is still more than one month to go! However, we are receiving many requests asking what we are working on at SQLBI. I wanted to write… Read more
Feb 18-20 - Phoenix
Video Training
Introducing DAX Video CourseFree
SQL database in Fabric
In the mass of announcements made at Microsoft Ignite, I want to mention the SQL database in Fabric, which finally closes a gap we had in Power BI for many years. In May 2022, Microsoft launched Power BI Datamarts in… Read more
Computing open orders with visual calculations in DAX
This article describes the use of visual calculations for a scenario where they may be particularly relevant: computing open orders at the end of a time period. Read more
DAX Patterns
ABC classification
The ABC classification pattern classifies entities based on values grouping entities together that contribute to a certain percentage of the total A typical example of ABC classification is the segmentation of products entity based on sales value The best-selling products… 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