4 ms·
To answer my own question: looks like all you need is Excel 2016 or better. https://powerquery.microsoft.com/en-us/excel/ https://powerquery.microsoft.com/en-u
by hn_version_0023 5y ago
To answer my own question: looks like all you need is Excel 2016 or better.
https://powerquery.microsoft.com/en-us/excel/ https://powerquery.microsoft.com/en-us/excel/
- Closi 5y agoAbsolutely! I would add though that you really need to follow a tutorial/book to make everything make sense in it. I read a book by Rob Collie - but any well reviewed book on DAX should do it. The book “Supercharge Excel - When you learn DAX…” looks like it covers similar information but more up to date. The analysis pattern is usually importing data and cleaning it in PowerQuery, then building relationships between tables in the data model view, and then analysing it via a ‘PowerPivot’ Table. PowerPivot then has new functionalities compared to a regular pivot table (eg measures) that allow for automatically calculating columns based on context and some additional capabilities you don’t get in excel.
- hn_version_0023 5y agoThank you kindly; I’ll look into your suggestions!