Forum Discussion
Solved
How to make column for sorting ?
Hi, In my table I have rows values which has no sort in its data source (direct query), as below: ColumnA High Medium Low So I figured I must create new column and create some so...
I prefer to do my data modelling in Power Query.
Hope this helps.
You could also key in the Sort column by modifying the Source step rather than defining a custom column (assuming the table was created in the query editor to begin with, of course).
Hi,
Sure, but I'm using Direct Query (which I didn't tell in this thread). So have limitation of modifying source, especially cannot add table.
Thanks