Forum Discussion

mkane12's avatar
mkane12
Helper I
1 year ago
Solved

sorting months in order

how can I sort my months in order?   
Need Help
  • v-tejrama's avatar
    v-tejrama
    1 year ago

    Hi mkane12 ,

     

    Thank you for your follow-up, and you’re correct to highlight that. If you’re already using a date table, such as a Calendar table with all dates included, there’s no need to create a separate Month table just for sorting. You can sort the month names directly in your existing date table.

    Make sure your table has a column for the month name (like "January", "February") and another for the month number (1 to 12).

     

    Thank you.

     

mkane12's avatar
mkane12
Helper I
1 year ago

hi, my months are part of a date field, I do not have a column with just Months

MasonMA's avatar
MasonMA
Super User
1 year ago

Hi mkane12 ,

This wouldn't be a good long-term strategy, but for now if you just wanted to sort them with a simple way, you'd still need to extract your MonthNumber from your date by creating one new calculated column. (To use below DAX, You date should be in 'Date' data type, not 'Text' data type)

MonthNumber = MONTH('Table'[Date])

then Select MonthName column by going to Column tools, Sort by column 'MonthNumber'.