Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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
Go to 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 =
The Mythical DAX Index - Microsoft Power BI Community
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.