Forum Discussion

VoltesDev's avatar
VoltesDev
Icon for Helper V rankHelper V
4 years ago
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...
Need Help
Tips and Tricks
  • KNP's avatar
    KNP
    4 years ago

    I prefer to do my data modelling in Power Query.

    Hope this helps.

     

KNP's avatar
KNP
Icon for Super User rankSuper User
4 years ago

I prefer to do my data modelling in Power Query.

Hope this helps.

 

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

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).

  • VoltesDev's avatar
    VoltesDev
    Icon for Helper V rankHelper V
    4 years ago

    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