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
GENERATESERIES in DAX: Create Continuous Number Ranges
In this article, we will learn how to use GENERATESERIES in DAX to create a continuous range of…
Read
Creating Reference Tables Using DATATABLE in DAX
In this article, we will learn how to create a reference table directly inside a DAX query using…
Read
CROSSJOIN in DAX: Create a Cartesian Product of Tables
In this article, we will learn how to use CROSSJOIN in DAX to create a Cartesian product between…
Read
Understanding GENERATE in DAX with Practical Examples
In this article, we will learn how to use GENERATE in DAX to combine two table expressions and…
Read
GENERATEALL in DAX: Create a Cartesian Product with Matching Rows
In this article, we will learn how GENERATEALL works in DAX. We will use a Students table and…
Read
NATURALINNERJOIN in DAX: Combining Two Tables Using Common Columns
In this article, we will learn how to use NATURALINNERJOIN in DAX to combine two tables based on…
Read
NATURAL LEFT OUTER JOIN in DAX – Complete Step-by-Step Guide
In this article, we will learn how to use NATURALLEFTOUTERJOIN in DAX to combine two tables using their…
Read
SUMMARIZE in DAX: Group Data and Calculate Aggregations
In this article, we will learn how to use the SUMMARIZE function in DAX to group data by…
Read
Understanding ROLLUP in DAX: Subtotals and Grand Totals with SUMMARIZE
In this article, we will learn how to use ROLLUP with SUMMARIZE in DAX to generate grouped results…
Read
ROLLUPGROUP in DAX: Grouping Columns Without Intermediate Subtotals
In this article, we will learn how to use ROLLUPGROUP together with ROLLUP inside SUMMARIZE to create grouped…
Read
SUMMARIZECOLUMNS in DAX: Group Data and Calculate Aggregated Values
In this article, we will learn how to use SUMMARIZECOLUMNS in DAX to group data by a column,…
Read
ROLLUPADDISSUBTOTAL in DAX: Add Subtotals and Grand Totals
In this article, we will learn how to use ROLLUPADDISSUBTOTAL with SUMMARIZECOLUMNS to add subtotals and a grand…
Read
ADDMISSINGITEMS in DAX: Including Missing Categories in Query Results
In this article, we will learn how to use ADDMISSINGITEMS in a DAX query to include items that…
Read
ROLLUP and Subtotals in DAX Using ROLLUPADDISSUBTOTAL and ADDMISSINGITEMS
In this article, we will learn how to create subtotals and grand totals in a DAX query using…
Read
DAX SUMMARIZE vs GROUPBY: Grouping Data and Calculating Tax
In this article, we will learn how to group data by a column and calculate an aggregated value…
Read
DAX Set Functions – EXCEPT, INTERSECT, UNION and COUNTROWS in DAX: Compare, Merge and Count Tables
In this article, we will learn how to compare and combine tables using EXCEPT, INTERSECT, and UNION, and…
Read
TOPN in DAX: Find Top, Least, and Top N Categories
In this article, we will learn how to use the TOPN function in DAX to identify the highest…
ReadAggregation
COUNT vs COUNTX in DAX: Understanding Counting Functions
In this article, we will learn how to use COUNT and COUNTX in DAX to count values in…
Read
Counting Boolean Values in DAX Using COUNTA and COUNTAX
In this article, we will learn how to count values in a DAX table, with a special focus…
Read
Counting Blank Values in DAX Using COUNTBLANK
In this article, we will learn how to identify and count blank values in individual columns using the…
Read
Counting Rows in a Table Using COUNTROWS in DAX
In this article, we will learn how to count the number of rows in a table using COUNTROWS…
Read
Counting Unique Values Using DISTINCTCOUNT and DISTINCTCOUNTNOBLANK in DAX
In this article, we will learn how to count unique values in DAX using DISTINCTCOUNT and DISTINCTCOUNTNOBLANK. We…
Read
Finding Minimum Values Using MIN and MINA in DAX
In this article, we will learn how to find the minimum value from columns and compare values using…
Read
Finding the Minimum Value of an Expression Using MINX in DAX
In this article, we will learn how to use MINX in DAX to evaluate an expression for every…
Read
Finding Maximum Values Using MAX, MAXA and MAXX in DAX
In this article, we will learn how to find maximum values in DAX using MAX, MAXA, and MAXX.…
Read
SUM vs SUMX in DAX: Understanding Row-by-Row Calculations
In this article, we will learn the difference between SUM and SUMX in DAX using a simple example.…
Read
PRODUCT vs PRODUCTX in DAX: Handling Blank Values with COALESCE
In this article, we will learn how to calculate the product of values using PRODUCT and PRODUCTX in…
Read
Understanding AVERAGE, AVERAGEX and AVERAGEA in DAX
In this article, we will learn the difference between AVERAGE, AVERAGEX, and AVERAGEA in DAX. Although all three…
Read