Forum Discussion
sorting months
dears
i have a chart where the dates are not sorted correctlly, the date data i have are in text form JAN-DEC
im trying to creat a new column with this DAX: Month number = month(tablename[Month]) so i can sort correctlly but when i create this column it give me this errorr : Cannot convert value 'Jan' of type Text to type Date.
Hi 160475 ,
There is a tip to convert Month name to Month number—— combine Month name and " 1" , then change its type to DateTime, finally use MONTH() to get the number:
Month Number = MONTH( CONVERT( MAX('Table'[Month]) &" 1", DATETIME))In visuals , you could apply it to Tooltips field , and then sort by it:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi 160475 ,
There is a tip to convert Month name to Month number—— combine Month name and " 1" , then change its type to DateTime, finally use MONTH() to get the number:
Month Number = MONTH( CONVERT( MAX('Table'[Month]) &" 1", DATETIME))In visuals , you could apply it to Tooltips field , and then sort by it:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi 160475
Do you have a Date column? Month needs Date, Month number = month(tablename[Date]), even if you use SWITCH to get month number from your current text, it still has a circular dependency error...
