Forum Discussion

vj123456's avatar
vj123456
New Member
3 years ago
Solved

DAX - Index

Hi Team,

how to get the index number like this in calculated column using DAX.

I don't need Power Query solution, RANKX also.

the order of coutry should change

 

CountryIndex
Canada1
France2
Germany3
USA4
Bermuda5
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi vj123456 ,

     

    You could create a calculated table.

    DAX Indexed Table = 
    VAR __SourceTable = 'Table'
    VAR __Count = COUNTROWS(__SourceTable)
    VAR __SortText = CONCATENATEX(__SourceTable,[Country],"|")
    VAR __Table = 
        ADDCOLUMNS(
            GENERATESERIES(1,__Count,1),
            "Country",PATHITEM(__SortText,[Value],TEXT)
        )
RETURN
    __Table

    Reference:

    The Mythical DAX Index - Microsoft Power BI Community

     

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi vj123456 ,

     

    You could create a calculated table.

    DAX Indexed Table = 
    VAR __SourceTable = 'Table'
    VAR __Count = COUNTROWS(__SourceTable)
    VAR __SortText = CONCATENATEX(__SourceTable,[Country],"|")
    VAR __Table = 
        ADDCOLUMNS(
            GENERATESERIES(1,__Count,1),
            "Country",PATHITEM(__SortText,[Value],TEXT)
        )
RETURN
    __Table

    Reference:

    The Mythical DAX Index - Microsoft Power BI Community

     

    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.