Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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

       

      • HoangHugo's avatar
        HoangHugo
        Icon for Solution Specialist rankSolution Specialist
        3 years ago

        Hi, refer to a table, we use apostrophe '

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.