Forum Discussion
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 ...
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.
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.
It blocks here --> RETURN LOOKUPVALUE( Soert_Org[Index]
you have to use a calculated column .
sharing the pbix FYR.
how can i attach the pbx file?
you can upload it in a google drive and share the link to download.
But i have attached pbix file with solution. can you please check and confirm