Forum Discussion
Natural sort order for text
It depends on the definition of "Natural"...
My suggestion would be to add a column with the numeric part, sort on that column and then remove that column, as illustrated in this 30 sec video.
Unfortunately though this is not a substitute for Sort By Column in the Data View (you'll still have to do Sort By Column!)
And then don't forget about this sort order column when you are using the ALL function!
Sean so apparently, one can't specialize in Power Query without sufficient DAX knowledge... :smileyembarrassed:
If I understand corrrectly, the number column I created in my solution should be kept, so it can be used as sort column in the Data View?
Yes duplicate the original column - split and create your Sort Column in the Query Editor - and then use that column to Sort By!
But again don't forget you've applied this Sort or the ALL function will not give you the correct result!
I almost started rebuilding a data model - because I couldn't figure out why I was getting wrong results...
http://community.powerbi.com/t5/Desktop/ALL-Function-Mystery/m-p/107458/highlight/true#M45087
