Topic: DAX
-
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
-
Introduction to DAX window functions and apply semantics through several examples to understand their capabilities and performance. Delivered by Marco Russo at SQLBits 2024. Watch now
-
This article clarifies how DAX evaluates variables, which is important to avoid common mistakes when using DAX for the first time. Read more
-
This article describes the DAX filter context using a conceptual model based on a visual representation. Read more