Amsterdam, NLRe-using visual formatting in and across Power BI reports
Kurt BuhlerThis 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
SQLBI+ updates in December 2024
Marco RussoWe 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
Feb 18-20 - Phoenix
Video Training
Introducing DAX Video CourseFree
Blank 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
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
DAX Patterns
Like-for-like comparison
The like-for-like sales comparison is an adjusted metric that compares two time periods restricting the comparison to products or stores with the same characteristics In this example we use the like-for-like technique to compare the sales of Contoso stores that… 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