-
This 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
-
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
-
Still some consideration about Gemini. In the last few days, I've seen some interesting posts and comments. Chris is still worried about the lose of control, and I agree with him that metadata are a key part of a complete BI solution, and today we are Read more
-
I will be a speaker at PASS Summit 2010 (November 8-11, 2010 - Seattle, WA) and sessions have been published yesterday. I am currently writing the last chapter of the book about PowerPivot that will be available in September, so I’m confident it will Read more