DAX - Index

[vj123456]

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
France	2
Germany	3
USA	4
Bermuda	5

[Anonymous · Accepted solution]

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.