Topic: DAX
-
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
-
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
-
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
-
This article describes the best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. Read more
-
We are proud to announce the availability of our new book, Optimizing DAX. 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
-
This article describes how to compare time series that occur in different periods by standardizing the timelines to days since a specific event. Read more
-
Almost a year ago, we announced the release of three sections (core concepts, formula engine, and VertiPaq); in November 2023, we released the DirectQuery over SQL section; now, in April 2024, we release the last section of Optimizing DAX about… Read more