Forum Discussion
Sorting DAX date table
I currently have a date table I use for my table matrix. Im trying to show 2020 and 2021 data in the matrix, but want it sorted desending showing jan 4 2021 first and going down. I cant seem to get...
Sorry I have been OOO. I was able to just use the main date and sort it that way instead of by month, day , year
HI Anonymous,
I'm not so clear about your descriptions, can you please share some dummy data with the expected result (the way similar as the above blog link mention) to help us clarify your scenario and requirements?
BTW, if you are working with situations that similar as creating 'sorting order' on a calendar based on fiscal date, you can take a look at the following blog:
DAX 101: Sorting months in fiscal calendars
Regards,
Xiaoxin Sheng