Forum Discussion
PowerPivot
Hi,
So, I already know that PowerPivot is not included in Office365 subscription (which is the one I have), however, I have Power BI Desktop, and SSAS installed on my machine. Is there any goo...
Basically both are similar under the hood - both use M and DAX language.
M is used in Power Query (i.e Get & Transform in Excel 2016) and in the query tool for Power BI Desktop.
DAX (Data Analysis Expressions) is the language used in Power Pivot and Power BI Desktop.
M is to query your data sources, clean and load data.
DAX is to analyze the data (Measures etc..)
So personally, if you learn in one you will know it in the other. There is a wealth of information out there, and as you know, here you will find a wealth of knowledge.
Thank you Tanya.