Forum Discussion

AOD's avatar
AOD
Helper III
6 years ago
Solved

sort by 2 columns

Hi All, 

 

Need help, I want to sort the table using both fields Name ( asc ) and modified on(desc). I have sorted in the source query editor as as below but when I take these fields in layout , it is not sorted by both. 

#"Sorted Rows" = Table.Sort(hs_contactfieldaudits,{{"modifiedon", Order.Descending}}),
#"Sorted Rows1" = Table.Sort(#"Sorted Rows",{{"name", Order.Ascending}}),

 

 

Thanks for your help. 

AOD

Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, AOD 

     

    You may click the column header 'Name' and make it sorted ascending, and then Shift+click the column header 'modifiedon' to make it sorted descending.

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies