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.
Hi,
I suggest creating a new table like below, instead of creating one column by one column.
Once the new table is created by using the below formula, then the ColumnA can be sorted by the Sort column.
New Table =
DATATABLE (
"ColumnA", STRING,
"Sort", INTEGER,
{
{ "High", 1 },
{ "Medium", 2 },
{ "Low", 3 }
}
)