Forum Discussion
Show ranking based on text
Hi. How do I show a ranking(1-10) of this column? I have already made a TopN but I would like to see the ranking number next to it. Best regards, Lisa
Hi Anonymous ,
You could try this calculated column.
Ranking = RANKX('Table',[Text],,ASC,Dense)You can download my attachment for more details.
However, I guess you only want an index column, right? Please refer to
Add an index column - Power Query | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
You could try this calculated column.
Ranking = RANKX('Table',[Text],,ASC,Dense)
You can download my attachment for more details.
However, I guess you only want an index column, right? Please refer to
Add an index column - Power Query | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.