Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 '
User | Count |
---|---|
134 | |
74 | |
72 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |