How to get months in correct order ?

[Anonymous]

I applied this dax to get a new month column from date : FORMAT(Table[calendar_date],"MMM")
But I'm getting following result:

Now how can I get this month column in actual order of months?

[tamerj1 · Accepted solution]

@Anonymous 
Ok I think you just want to oder them. Create a new a month number column (if you don't already have it) whcih is MONTH (Table[calendar_date])

Then use the option "Sortb By Column" to sort the Month column by the Month Number column

[Anonymous]

Reverting FORMAT(DATE (1, MONTH (Table[calendar_date]), 1), "MMM") to FORMAT(Table[calendar_date],"MMM") and then sorting by Month Name by Month No. worked.

Thank you @tamerj1 as always

[Anonymous]

I created new month no. column but on sorting month name by month no. it is showing this

[tamerj1]

@Anonymous 

Please share a screenshot of the table

[Anonymous]

it is not allowing the sort because FORMAT(DATE (1, MONTH (Table[calendar_date]), 1), "MMM") gave "Dec" even for null values, so now "Dec" has month no. as 12 and null (since month no. has null for null date)

[Anonymous]

can only share this much with you 😞

[tamerj1]

Hi @Anonymous 

please use

FORMAT(DATE (1, MONTH (Table[calendar_date]), 1), "MMM")

[Anonymous]

Hi @tamerj1 ,
it doesn't change anything, still getting the same result

[tamerj1]

@Anonymous 
YOu are creating a calculated column right. Please share a screenshot to the result you got from the table itself not from the visual.