Retrieving Tables and Columns Using EVALUATE and SELECT COLUMNS in DAX
In this article, we will learn how to retrieve an entire table, a single column, and multiple columns…
ReadData Analysis Expressions (DAX)
Articles and deep-dives organized by module — pick a module to browse, or a title to start reading.
Fundamentals
How to Sort Tables in DAX Using ORDER BY
In this article, we will learn how to sort a table in DAX using ORDER BY. We will…
Read
START AT in DAX: Retrieve Data from a Specific Starting Point
In this article, we will learn how to use START AT in DAX queries to begin retrieving data…
Read
Evaluating Sales and Calculating Total Sales and Average Sales in DAX
In this article, we will learn how to retrieve the complete Sales table and calculate Total Sales and…
Read
Using Variables in DAX Queries and Measures
In this article, we will learn how to use VAR and RETURN in DAX to store intermediate calculations,…
Read
Using Variables in DAX to Calculate Total Tax and Average Tax
In this article, we will learn how to use DEFINE, VAR, and EVALUATE in DAX to calculate tax…
ReadOperators
Arithmetic Operations in DAX: Calculate Profit with Inclusive and Exclusive Tax
In this article, we will learn how to perform arithmetic operations in DAX using variables, calculate profit with…
Read
DAX Comparison Operators: Equal To, Not Equal To, Greater Than and Less Than
In this article, we will learn how to use comparison operators in DAX to filter tables and identify…
Read
Text Concatenation Operator & in DAX
In this article, we will learn how to use the text concatenation operator (&) in DAX to combine…
Read
DAX Logical Operations: AND, OR, and IN Operators Explained
In this article, we will learn how to use logical operators in DAX to filter data based on…
ReadTable Manipulation
DAX DISTINCT Function: Remove Duplicate Rows and Get Unique Values
In this article, we will learn how to use the DISTINCT function in DAX to retrieve unique values…
Read
ADDCOLUMNS in DAX: Add Calculated Columns to a Table
In this article, we will learn how to use ADDCOLUMNS in DAX to add calculated columns to an…
Read