Show ranking based on text

[Anonymous]

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

[v-stephen-msft · Accepted 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.

[HoangHugo]

Hi,

rank =RANKX([table name],[*Material],,1,Dense)

[Anonymous]

@HoangHugo 
Am I doing it wrong? It gives me an error. 

[HoangHugo]

Hi, refer to a table, we use apostrophe '