Forum Discussion

spaturu3234's avatar
spaturu3234
Frequent Visitor
9 years ago
Solved

How Do I Sort Text Columns

I have a column of descriptions , How Do I Sort that column ? So that I can compare with Previous value to identify multiple keys   ID    Desc 1      Apple 2      Ball 3      Cat 4      Apple ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    spaturu3234

     

    Hi,

     

    Sorting will be easy. Click dropdown of the column and choose Sort Ascending in Query Editor. We also can add an index to keep the new order. Could you tell me the mean of the output? 

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi,

     

    That all depends on the output you want. Dax has some funtions to do sorting work. But they don't work the way like sort here. Such as Rankx, TopN. 

     

    Best Regards!

    Dale.

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

spaturu3234

 

Hi,

 

Sorting will be easy. Click dropdown of the column and choose Sort Ascending in Query Editor. We also can add an index to keep the new order. Could you tell me the mean of the output? 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

spaturu3234's avatar
spaturu3234
Frequent Visitor
9 years ago

Can I do that in Dax ?

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi,

     

    That all depends on the output you want. Dax has some funtions to do sorting work. But they don't work the way like sort here. Such as Rankx, TopN. 

     

    Best Regards!

    Dale.