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   Country Index Canada 1 ...
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.

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.