Topic: Power BI
-
This article is about how rules like “avoid pie charts” can be useful for beginners, but also unhelpful in real-world scenarios with more nuance. Instead of learning rules about “how”, try to understand the “why”. 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
-
Optimize inventory calculations in DAX by using snapshots to avoid the computational cost of a complete running total. Watch now
-
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
-
Overview of the techniques and the tools (free and commercial) available to optimize the performance of DAX expressions in Power BI models. You learn what you can do with Performance Analyzer included in Power BI, how to extract query plans… Watch now
-
This session introduces the Visual Calculations feature in Power BI, which provides a different way to write DAX expressions based on the results visible in a visual and without accessing other information in the semantic model. Because the data in… Watch now
-
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
-
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
-
If you think that the end of the year would have been a quiet time because the Power BI team will skip their monthly release (but are we sure?), you might be reassured (or disappointed depending on your perspective) looking at the news I have in this Read more
