Topic: DAX
-
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 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
-
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
-
This article is about how to read and use bullet charts when comparing actuals to a target in Power BI, and the different options you have available to make these charts in Power BI reports. Read more
-
It is not common to face rounding differences in Power BI. However, when it happens, users are usually disappointed and surprised. Read more
-
This article describes why week-based calendars (like 4-4-5) are important for specific industries and how to use them effectively in Power BI. Read more
-
The choice of data types can affect precision and performance because of internal conversions. This article shows how the right choice of data type and DAX code makes a significant difference. Read more
