Forum Discussion
JayZee70
Helper I
Helper IUpper case in the Calender Weekday name
Hello! I have a small issue with my Weekday Name column. I want the first letter to be an upper case. What do I do? This could perhaps be some issue in Microsft settings, but does anyone know ...
Hi JayZee70 ,
Please try to update your DAX to look something like this:
Weekday Name = UPPER(LEFT(FORMAT(WEEKDAY('Calendar'[Date], 1), "DDDD"), 1)) & LOWER(MID(FORMAT(WEEKDAY('Calendar'[Date], 1), "DDDD"), 2, LEN(FORMAT(WEEKDAY('Calendar'[Date], 1), "DDDD")) - 1))Hi JayZee70 ,
Understood, you can do this:
Month Name = UPPER(LEFT(FORMAT('Calendar'[Date], "MMMM"), 1)) & LOWER(MID(FORMAT('Calendar'[Date], "MMMM"), 2, LEN(FORMAT('Calendar'[Date], "MMMM")) - 1))Hi JayZee70 ,
You got month name and month number column in your calendar like this:
Now select the month name column and go to Sort by Column and choose by Month No:
Bibiano_Geraldo
Super User
Super UserHi JayZee70 ,
to get Month name you can use the following DAX:
Month Name = FORMAT('Calendar'[Date],"Mmmm")This will result in something like this:
JayZee70Helper I
Helper IYeah, that is about what I have done, I did create a new column.
But I need the names to start with a capital letter.
Like you helped me with the weekdays.
- Bibiano_Geraldo
Hi JayZee70 ,
Understood, you can do this:
Month Name = UPPER(LEFT(FORMAT('Calendar'[Date], "MMMM"), 1)) & LOWER(MID(FORMAT('Calendar'[Date], "MMMM"), 2, LEN(FORMAT('Calendar'[Date], "MMMM")) - 1))- JayZee70
Thank you Geraldo!
It works great.
- Bibiano_Geraldo
You're welcome