-
This article describes the differences between the ALL and CROSSFILTERED functions in DAX. Read more
-
This article describes how to optimize inventory calculations in DAX by using snapshots to avoid the computational cost of a complete running total. Read more
-
After another year, it is time to recap what happened in the DAX and SQLBI worlds and provide a few spoilers about 2025! Read more
-
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
-
This 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
-
No, 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
-
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
-
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
-
There are not so many books about MDX and it’s strange considering that it is a very sophisticated languages that requires years for learning (I’m not kidding). I started learning MDX in 1999 and after so many years, I still have to learn something. I’ve Read more
-
It is finally available the SSAS 2008 book I wrote with Chris Webb and Alberto Ferrari : Expert Cube Development with Microsoft SQL Server 2008 Analysis Services . The book is also available on Amazon . You can also read a sample chapter for free. We Read more