Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Another sort by date problem

Hi.   Im going crazy trying to just get the date table to be sorted correctly   I used this dax:   Calendar = var _calendar = CALENDAR("1/1/2020", "12,31,2023") return ADDCOLUMNS(_calendar...
Need Help
  • MURTAZA's avatar
    MURTAZA
    5 years ago

    Follow these steps:

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Your DAX table expression worked fine for me, including the Sort By column.  Please see this article/video on how to create Date tables that don't need to be sorted.  There is one you can copy/paste and use directly.

No Sort Date Tables! – Hoosier BI

 

Pat