How Do I Sort Text Columns

[spaturu3234]

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

5      Cat

I need to sort this column:

ID      Desc

1        Apple

4        Apple

2        Ball

3        Cat

5        Cat

Final Output 

ID       Desc        CalColumn

1         Apple        1,4

2         Ball            2,6

3         Cat             NULL

OR

ID    Desc              CalColumn

1      Apple                 X

2      Ball                     NULL

3      Cat                      X

4      Apple                  X

5      Cat                      X

[v-jiascu-msft · Accepted solution]

@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 · Accepted solution]

@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]

Can I do that in Dax ?

[v-jiascu-msft · Accepted solution]

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.