Forum Discussion
Del235
Helper III
Helper IIIconvert date to month name
How do I convert date to month name? I see the dax to convert date to month number but not month name
Del235Helper III
Helper IIIHow do I make the data type date? What I'm trying to do is get the Month name to to sort as Jan - Dec. This leaves it as text and sorts alphabetically
sevenhills
Super User
Super UserIn the data view,
create two columns. one for month number and other for month name.
Month Number = Format([YourDate], "MM")Month Name = Format([YourDate], "MMM")
select the month name column, in the column tools menu, click "Sort by column". Here, by default it will show the month name column. Now, you click "Month number" column.
In all your visuals of month name, it will be sorted by Month number.
Optional: you can hide the month number column for the users.
Hope it helps!
- Del235
I have something like this, so this does work. I didn't want two columns.