Forum Discussion
Sorting Time Intelligence
I am playing with time intellgence functions. I added an auto calendar with the calendarauto function and then added a year and month to that table with dax. I related the date table to another table with loan information. Then I did a totalytd for loan amount by year and month from the date table.
The table sorts by year but alphabetically by month which is poor formatting to show ytd. How can I get the months to sort chronologically?
You need to add a numeric MONTH([Date]) column and have your text month sort by this column.
2 Replies
You need to add a numeric MONTH([Date]) column and have your text month sort by this column.
Can you put a sort hierarchy on tables - to sort by more than one column? Sorting on month an then sorting on year worked ok here but are there options for "tiering" sorts?
