Forum Discussion

Naveennegi119's avatar
Naveennegi119
Icon for Helper III rankHelper III
8 years ago
Solved

Index data highest to lowest

Hi all,     Data     Expect result Sub Value Index     Sub Value Index ABC 30       ABC 30 4 ABC 13       ABC 13 9 ABC 44       ABC 44 2 ABC 25  ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi Naveennegi119

     

    You can add a new calculated column using the following formula.

     

    New Column = 
    RANKX(
        FILTER('Table1',
            'Table1'[Sub]=EARLIER('Table1'[Sub])
            ),
            'Table1'[Value]
            )

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Naveennegi119

 

You can add a new calculated column using the following formula.

 

New Column = 
    RANKX(
        FILTER('Table1',
            'Table1'[Sub]=EARLIER('Table1'[Sub])
            ),
            'Table1'[Value]
            )

  • Naveennegi119's avatar
    Naveennegi119
    Icon for Helper III rankHelper III
    8 years ago

    Hi Phil_Seamark,

     

    Thanks for fast reply.

     

    it's working with small issue.

     

    it's giving same no. for duplicate data.

     

    Note:- Change few data to show you result.

     

    any advise for that.

    Regards,

    NICK

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Naveennegi119,

       

      Actually, current power bi will rank duplicate records as same ranking number.
      AFAIK, power bi not contains row index and column index, so it is impossible to ranking duplicate records as different numbers.

       

      Regards,

      Xiaoxin Sheng