Forum Discussion

AlessandroBet's avatar
AlessandroBet
Helper V
1 year ago
Solved

Column index

Hi,   i need to insert a column index matching the value of other column   Ex:   Column to match --> Index A                                   1 B                                   2 C      ...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi AlessandroBet - you can create a calculated column as like below:

     

    Index1 =
    VAR LookupTable = ADDCOLUMNS( DISTINCT('soert_org'[Column to match]), "@Index", RANKX( DISTINCT('soert_org'[Column to match]), 'soert_org'[Column to match], , ASC, DENSE ) )
    RETURN LOOKUPVALUE( Soert_Org[Index], Soert_Org[Column to match], 'soert_org'[Column to match] )
     
    Hope this works.
AlessandroBet's avatar
AlessandroBet
Helper V
1 year ago

thank you for your fast replay but i want add indesx with DAX code

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    Hi AlessandroBet - you can create a calculated column as like below:

     

    Index1 =
    VAR LookupTable = ADDCOLUMNS( DISTINCT('soert_org'[Column to match]), "@Index", RANKX( DISTINCT('soert_org'[Column to match]), 'soert_org'[Column to match], , ASC, DENSE ) )
    RETURN LOOKUPVALUE( Soert_Org[Index], Soert_Org[Column to match], 'soert_org'[Column to match] )
     
    Hope this works.
    • AlessandroBet's avatar
      AlessandroBet
      Helper V
      1 year ago

      It blocks here --> RETURN LOOKUPVALUE( Soert_Org[Index]