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.
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.
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.
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.