Forum Discussion
vj123456
3 years agoNew Member
DAX - INDEX
need DAX for below index column
no need Power query solution and RANKX function.
Order of countrty should not change
| Country | Index |
| Canada | 1 |
| France | 2 |
| Germany | 3 |
| USA | 4 |
| Bermuda | 5 |
1 Reply
- AnonymousNot 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.