6 ms·
> The problem is I would guess less than 1% of Excel users actually understand this functionality Do you have any recommendations for getting started with this
by hn_version_0023 5y ago
> The problem is I would guess less than 1% of Excel users actually understand this functionality
Do you have any recommendations for getting started with this?
- hn_version_0023 5y agoTo 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!