Forum Discussion

vj123456's avatar
vj123456
New Member
3 years ago

DAX - INDEX

need DAX for below index column

no need Power query solution and RANKX function.

Order of countrty should not change

CountryIndex
Canada1
France2
Germany3
USA4
Bermuda5

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi vj123456 ,

    The best way is to use rankx() function or power query to create index column, or it is complex to realize it.

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.