Download Excel File: https://excelisfun.net/files/EMT1698.xlsx
Learn how to rank in Power Query. Power Query Steps and M Code works in Excel or Power BI.
Topics:
1. (00:00) Introduction.
2. (00:23) Load data.
3. (00:38) Group By Product to get Total Sales
4. (01:06) Sort Total Sales
5. (01:14) Add Index Column
6. (01:29) Group By Total Sales, but make MIN aggregate calculation on Index Column
7. (02:08) Expand.
8. (02:26) Re-arrange columns.
9. (02:32) Summary of steps for ranking
10. (02:44) Load.
11. (02:51) Total row in an Excel Table (Power Query Excel Output).
12. (03:06) Update data and fresh data source.
13. (03:23) Summary, Closing and Video Links