Topic: DAX
-
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
-
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
-
This article is about creating dynamic images in DAX measures to visualize data in tables or cards, including an easy way to do this in Figma, and a caution for using these DAX measures in real-life scenarios. Read more
-
This article describes the DAX context transition using a conceptual model based on a visual representation. Read more
-
One of the few golden rules in DAX is to always filter columns and never filter tables with CALCULATE. This article explains the rationale behind the rule. Read more
-
This article describes the DAX row context using a conceptual model based on a visual representation. Read more
-
Introduce Power BI aggregations with practical examples, evaluate pros and cons, and learn how to use alternative approaches by using DAX to control the aggregation used. Delivered by Marco Russo at SQLBits 2024. Watch now
-
Learn when to use ALL / VALUES instead of ALLEXCEPT in DAX calculations. Sessions delivered by Marco Russo at SQLBits 2024. Watch now
