Sorting Time Intelligence

[Maureen]

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?  

[Greg_Deckler · Accepted solution]

You need to add a numeric MONTH([Date]) column and have your text month sort by this column.

[Maureen]

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?