Analytics Hub · Free
Blogs
Free, clear written guides with examples, organised into blog courses so you always know where to start.
40 blogs
Data Analysis Expressions (DAX)
-
Fundamentals 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.…
-
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 retrieve the complete Sales table, sort…
-
Fundamentals 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…
-
Fundamentals 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,…
-
Fundamentals 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…
-
Fundamentals 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.…
-
Operators 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…
-
Operators 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…
-
Operators 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…
-
Operators 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…
-
Table 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 from a column and remove duplicate…
-
Table Manipulation 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…
-
Table Manipulation 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…
-
Table Manipulation 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…
-
Table Manipulation 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…
-
Table Manipulation 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…
-
Table Manipulation 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…
-
Table Manipulation 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…
-
Table Manipulation 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…
-
Table Manipulation 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…
-
Table Manipulation 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.…
-
Table Manipulation 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,…
-
Table Manipulation 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…
-
Table Manipulation 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.…
-
Table Manipulation 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.…
-
Table Manipulation 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…
-
Table Manipulation 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.…
-
Table Manipulation 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.…
-
Table Manipulation 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…
-
Aggregation 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…
-
Aggregation 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…
-
Aggregation 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…
-
Aggregation 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…
-
Aggregation 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…
-
Aggregation 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…
-
Aggregation 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…
-
Aggregation 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…
-
Aggregation 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…
-
Aggregation 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…
-
Aggregation 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 blogs match your search.