Data Analysis Expressions (DAX)
Articles and deep-dives organized by module — pick a module to browse, or a title to start reading.
-
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 using EVALUATE and SELECTCOLUMNS in DAX.…
-
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 retrieve the complete Sales table, sort…
-
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 from a specific position. We will…
-
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 Average Sales using EVALUATE, ROW, SUM,…
-
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, simplify formulas, and create a reusable…
-
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 on total sales and average sales.…
-
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 inclusive and exclusive tax, and handle…
-
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 records that meet specific conditions. We…
-
Text Concatenation Operator & in DAX
In this article, we will learn how to use the text concatenation operator (&) in DAX to combine values from different columns and create…
-
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 multiple conditions. We will explore the…
-
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 from a column and remove duplicate…
-
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 existing table. We will calculate Tax…
-
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 numbers and generate a sequence with…
-
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 the DATATABLE function. We will understand…
-
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 two tables. We will start by…
-
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 how it differs from a simple…
-
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 a Payments table to understand how…
-
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 their common columns. We will also…
-
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 common columns. We will also learn…
-
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 one or more columns and calculate…
-
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 along with subtotals and grand totals.…
-
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 summary results with a total row,…
-
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, calculate aggregated values such as Total…
-
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 total to a grouped DAX query.…
-
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 are missing from the filtered result.…
-
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 ROLLUPADDISSUBTOTAL, ROLLUPISSUBTOTAL, and ADDMISSINGITEMS. We will…
-
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 using SUMMARIZE and GROUPBY in DAX.…
-
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 how to count rows using COUNTROWS.…
-
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 and lowest transactions and to find…
-
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 a table. We will also understand…
-
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 on Boolean values such as TRUE…
-
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 COUNTBLANK function in DAX. 📥 Practice…
-
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 in DAX. This is one of…
-
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 will also understand the important difference…
-
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 MIN and MINA in DAX. We…
-
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 row of a table and return…
-
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. We will also understand how MAXX…
-
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. We will also see how COALESCE…
-
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 DAX. We will also see how…
-
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 functions are related to calculating averages,…
No posts in this module yet.
No posts in this module yet.
No posts in this module yet.
No posts in this module yet.
No posts in this module yet.
No posts in this module yet.
No posts in this module yet.
No posts in this module yet.
No posts in this module yet.
No posts in this module yet.
No posts in this module yet.