-
Using variables in DAX makes the code easier to read, faster, and easier to debug. In this article, we discuss how and when to use variables, along with why they are so important in any DAX expression. 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 describes how variables should be used in DAX expressions involving IF and SWITCH statements in order to improve performance. 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
-
This article shows how to define variables in DAX queries and introduces the differences in scope when there are multiple EVALUATE statements. 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 how to use variables to optimize the performance of DAX expressions containing multiple instances of the same measure or the same sub-expression. 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 describes how to join tables in DAX when there are no relationships in the data model. The data lineage plays an essential role in this scenario. Read more
-
This article describes different techniques to debug a DAX measure that returns an incorrect result, with and without external tools. Read more