Forum Discussion
Nima Mohandesan
Jan 24, 2018Copper Contributor
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...
Tanya Denton
Jan 24, 2018Steel Contributor
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.
Nima Mohandesan
Jan 25, 2018Copper Contributor
Thank you Tanya.