Notifications
Clear all
Power Query
3
Posts
3
Users
0
Reactions
103
Views
Topic starter
Hi,
Is there a simple power query UI way to achieve ranking multiple cols ?
Rather then the rather complex M code https://www.excelforum.com/excel-formulas-and-functions/1274052-power-query-ranking-multiple-columns.html
Posted : 27/11/2019 5:01 am
Hi Chris,
You could just sort the first column, then add an index column from 1. Then sort the next column and add another index column and likewise for the third column.
Mynda
Posted : 27/11/2019 7:06 am
There is no UI ranking, but you can try this:
Sort 2017 column Descending, then add an index column, this index will be your 2017 ranking. Do the same for 2018 and 2019.
You can try other methods from here: https://www.excelguru.ca/blog/2018/06/14/ranking-method-choices-in-power-query/
Posted : 27/11/2019 7:41 am
