Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sort date in ascending order by Category using power query

Hi, I would like to know how to sort date in terms of Category, in the ascending order.

Category Date

A              Date 1

A              Date 2 (Earliest)

A              Date 3 ( Latest)

 

B              Date 4(Latest)

B              Date 5(Earliest)


C              Date 6(Latest)

C              Date 7(Earliest)
C              Date 8

 

and so on....


Thank you.

 

 

  • Hi Anonymous ,

    If I understood you correctly. First sort Category Order.Ascending and then Date Order.Descending.

     

2 Replies

  • Hi Anonymous ,

    If I understood you correctly. First sort Category Order.Ascending and then Date Order.Descending.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Yes. Sorry if i didn't phrase my question properly. Category is okay. Just that the date is in ascending order but the solution is there. Thanks!