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...
Anonymous , Where are you showing date , If you showing on column(pivot) you need to have sort column to change it to descending.
Create date if you do not have
Date = date([Year],[month], [day])
Date1 = date([Year],[month], [day])
Date Sort = rankx(all(Table), [Date],,desc)
Sort Date1 on date sort and use.
Refer to my video on this: https://www.youtube.com/watch?v=KK1zu4MBb-c
