Sort date in ascending order by Category using power query

[Anonymous]

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.

[Payeras_BI · Accepted solution]

Hi @Anonymous ,

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

[Anonymous]

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!