Forum Discussion
VoltesDev
Helper V
Helper VHow 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.
Jihwan_Kim
Super User
Super UserHi,
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 }
}
)