Forum Discussion
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
You could try... and change to the desired format.
In 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!
I have something like this, so this does work. I didn't want two columns.
10 Replies
StuartSmithPower Participant
You could try... and change to the desired format.
- sayaliredij
Solution Sage
HI Del235
You can use
Monthname = FORMAT('Table'[date_column], "MMM")Thanks and Regards,
Sayali
Please mark the question solved when done and consider giving a thumbs up if posts are helpful!!
- Idrissshatila
Super User
Del235How 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
sevenhillsIn 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.
- Idrissshatila
Hi Del235 ,
You could try StuartSmith's suggestion to format the date column, for Format() function, it will return a text type value.
If you want to sort the month from Jan to Dec, you could try sevenhills 's suggestion, create a new column with month number, sort the month number column, then sort the month name column by month number column.
Note: In Power BI, for text value, it sort by the ascii value.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Syndicate_AdminAdministrator
You'll see the name of the month, such as "January" or "February."
Just like in letter reverser, where you change the style of the text, here you change the format of the date!
