Topic: Variables
-
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 different techniques to debug a DAX measure that returns an incorrect result, with and without external tools. Read more
-
This article explains how to improve DAX queries using GENERATE and ROW instead of ADDCOLUMNS when you create table expressions. Read more
-
This article describes a very common optimization pattern that relies on variables to optimize conditional expressions in DAX. Read more
-
This article describes a naming convention for temporary columns in DAX expressions to avoid ambiguity with the measure reference notation. Read more
-
This article describes how to correctly use column references when manipulating tables assigned to DAX variables, avoiding syntax errors and making the code easier to read and maintain. Read more
-
This article shows how variables in DAX can impact the coding style, simplifying a step-by-step approach and improving the readability of your code. Read more
-
In this article, you learn a new feature in DAX 2015: variables. The 2015 version of the DAX language has many new functions, but none of them is a game changer for the language as variables are. Read more
-
This article shows how to define variables in DAX queries and introduces the differences in scope when there are multiple EVALUATE statements. Read more