sort table by DAX

[jaipalambati]

hi, I created a table using as follows:

test table = CALCULATETABLE(SELECTCOLUMNS(Table,  "Date", Table[DateKey],

"Accum", Table[Accum.],

"Daily", Table[Daily]))

I got the table as below: 

Accum    Daily     Date

0	0	3/12/2022 12:00:00 AM
0	0	2/12/2022 12:00:00 AM
0	0	1/12/2022 12:00:00 AM
0	0	3/12/2022 12:00:00 AM
0	0	2/12/2022 12:00:00 AM
0	0	1/12/2022 12:00:00 AM
0	0	3/12/2022 12:00:00 AM
0	0	2/12/2022 12:00:00 AM
0	0	1/12/2022 12:00:00 AM

But I need to sort by date in Ascending order and fix the date format (Short Date) using DAX. 

Desired output:

Accum Daily  Date

0	0	1/12/2022
0	0	1/12/2022
0	0	1/12/2022
0	0	2/12/2022
0	0	2/12/2022
0	0	2/12/2022
0	0	3/12/2022
0	0	3/12/2022
0	0	3/12/2022

please give me suggestions with DAX  only. Thanks

[lbendlin]

ORDERBY function (DAX) - DAX | Microsoft Learn