Topic: DAX
-
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
-
This article describes a simple approach that you can apply to improve your reports and dashboards. Read more
-
This article explains the unique behavior of apply semantics: a new way of computing table expressions when multiple rows are selected in DAX window functions. Read more
-
I am glad to be back in Australia in August 2024: we planned three Mastering DAX classes and two SQLBI Days about DAX Optimization. Read more
-
DAX is not like M when it comes to data manipulation, and it is not supposed to do that. However, if you need something in DAX similar to Table.FromList in M, this blog post is for you. If you have… Read more
-
This article describes the best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. Read more