What is DAX

What is DAX

Used in:

Purpose of DAX

We use DAX to be able to create new information from the data that we already have. For example, if we have two columns, one column for the quantity sold and another for unit price, we can use DAX to create a formula that will calculate the total price for that item.

Syntax

Power BI DAX Syntax Step 1

DAX vs M

DAX M
Data Expression Language Data Preparation Language
PowerBI, SSAS Azure Analysis Services Default language of Power Query, Microsoft Flow

DAX vs Power Query

DAX is used for Measures/Calculations (i.e Agrregate meausre, Adding calculated column etc.)

Power Query (M) is used for data preparation (Cleaning, Transformation etc.)