Forum Discussion
naga449
5 years agoFrequent Visitor
Adding Serial Number using DAX(Not in Transform data)
Hi Community, Could you please help me with this, I have a Dim Table with countries, Country India Australia South America North America Japan Germany I want to sort...
daxer-almighty
5 years agoSolution Sage
You can't do this in DAX alone. Sorry, you're out of luck. The only sort that DAX obeys natively is the alphabetical order of strings and the natural order of numbers/date(time)s (date(time)s are numbers in disguise). To have a different sort than the mentioned ones you have to create a column and manually insert the numbers by which you want to sort the column. This is best done either in PQ (using Add Column) or outside the system in some ETL layer or in the source.