What is DAX in Power BI?

DAX stands for Data Analysis EXpressions. We use this in Power BI Desktop rather than the Power Query Editor to most commonly create:

• Calculated columns - A column that lives inside of the table, which is calculated at the row level. An example is below, calculating the revenue per row.

• Measures - Something used in your visualisation. An example below, creating a measure for the total number of transactions within a table. It essentially counts the number of rows in the table, where one row represents a transaction. Measures must be aggregated so cannot be performed at a row level.

Similarly to Tableau's Table Calculations and Calculated Fields, there are different types of DAX functions, which can be explored further by clicking the links below:

  1. Mathematical Functions
  2. Aggregate Functions
  3. Logical Functions
  4. Text Functions
  5. Date/Time Functions
Author:
Zaman Bilal Iqbal
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab