Skip to content
BENIBIX Learn

Power Query vs DAX

People think Power Query and DAX are two names for one Power BI language. Power Query gets the data and cleans it before it is loaded. DAX works on the data after it is loaded, to add up numbers like total sales or growth on last year. Clean the rows with Power Query, then do the math with DAX.

Data📊 Analytics & BI

Power Query

A Microsoft tool in Excel and Power BI that gets and cleans data. It saves each step.

Power Query is Microsoft's tool for getting and cleaning data. It is built into Excel and Power BI. You connect to a source, like a file or a database. Then you click through steps, such as removing columns or filtering rows. Each step is saved and written in a language called M. When new data arrives, one refresh runs every step again.

Example
Each month Emma gets a sales CSV with the same mess. She cleans it once in Power Query. Now each new file takes one click on Refresh.
Why it matters
It turns hours of copy and paste into one click. The steps are the same every time, so fewer mistakes slip in.
Full entry
Data📊 Analytics & BI

Data Analysis Expressions (DAX)

The way to write sums and counts in Power BI.

DAX is the formula language of Power BI. It looks like Excel formulas, but it works on whole tables and columns. Most DAX is written as measures. These are numbers worked out when someone looks at a chart. The same measure gives the right answer for each filter, such as one region or one month. A function like CALCULATE changes which rows a measure looks at.

Example
A report shows sales and sales last year side by side. When the reader picks one store, both numbers change to that store.
Why it matters
A measure is written once and works under each filter. No one has to build the number again for each chart.
Full entry

In one line

Power Query
A Microsoft tool in Excel and Power BI that gets and cleans data. It saves each step.
Data Analysis Expressions (DAX)
The way to write sums and counts in Power BI.