Question: what is the difference between power query and dax?
Answer: M and DAX are two completely different languages. M is used in Power Query (a.k.a. Get & Transform in Excel 2016) and the query tool for Power BI Desktop. ... DAX is the formula language used in Power Pivot and Power BI Desktop. DAX uses functions to work on data that is stored in tables.