Date in Matrix Column how to sort ascending

Hi santoshlearner2 
For sorting the dates in descending order you need to have the column with its numeric value multiplied by (-1).
To attach it from the date table that was made with pq you can
1. duplicate the date column

2. change the data type to whole number:

3. multiply it by (-1)

Close and apply, and modify the date sort by this new column from the table view :

Result :

Unfortunately, I couldn't find a solution for the scenario where you're using a calendar created with DAX. However, that type of calendar is less flexible. I recommend using a PQ calendar instead. I've attached a sample file for your reference. You can find more information about PQ calendars, including a script for creation, in the link.

https://radacad.com/all-in-one-script-to-create-date-dimension-in-power-bi-using-power-query

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

Try to download my file and follow the steps / share link to your pbix and I will check...

You need to multiply it with (-1) not 1...
The column for sorting should have negative numbers...