Data Analysis Expressions (DAX)

Articles and deep-dives organized by module — pick a module to browse, or a title to start reading.

  1. Table Manipulation 8 Sep 2026 5 min read 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…
  2. Table Manipulation 8 Sep 2026 5 min 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 existing table. We will calculate Tax…
  3. Table Manipulation 23 Sep 2026 3 min 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 numbers and generate a sequence with…
  4. Table Manipulation 23 Sep 2026 6 min 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 the DATATABLE function. We will understand…
  5. Table Manipulation 23 Sep 2026 5 min 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 two tables. We will start by…
  6. Table Manipulation 23 Sep 2026 6 min 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 how it differs from a simple…
  7. Table Manipulation 23 Sep 2026 6 min 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 a Payments table to understand how…
  8. Table Manipulation 23 Sep 2026 4 min 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 their common columns. We will also…
  9. Table Manipulation 23 Sep 2026 5 min 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 common columns. We will also learn…
  10. Table Manipulation 23 Sep 2026 6 min 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 one or more columns and calculate…
  11. Table Manipulation 23 Sep 2026 4 min 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 along with subtotals and grand totals.…
  12. Table Manipulation 23 Sep 2026 4 min 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 summary results with a total row,…
  13. Table Manipulation 23 Sep 2026 4 min 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, calculate aggregated values such as Total…
  14. Table Manipulation 23 Sep 2026 5 min 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 total to a grouped DAX query.…
  15. Table Manipulation 23 Sep 2026 6 min 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 are missing from the filtered result.…
  16. Table Manipulation 23 Sep 2026 6 min 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 ROLLUPADDISSUBTOTAL, ROLLUPISSUBTOTAL, and ADDMISSINGITEMS. We will…
  17. Table Manipulation 23 Sep 2026 5 min 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 using SUMMARIZE and GROUPBY in DAX.…
  18. Table Manipulation 23 Sep 2026 7 min 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 how to count rows using COUNTROWS.…
  19. Table Manipulation 23 Sep 2026 6 min 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 and lowest transactions and to find…