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
Solved! Go to Solution.
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.
Hi,
rank =RANKX([table name],[*Material],,1,Dense)
Hi, refer to a table, we use apostrophe '
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
104 | |
73 | |
69 | |
47 | |
47 |
User | Count |
---|---|
161 | |
85 | |
76 | |
68 | |
67 |