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:
rajendraongole1
Super User
Super UserHi JayZee70 - you can achieve this at Power Query:
Open Power Query by selecting your data and clicking Data > Get & Transform Data > From Table/Range.
In Power Query, select the "Weekday Name" column.
Go to the Transform tab and click Format > Capitalize Each Word.
Close and load the data back into Excel.
HOpe this helps.
JayZee70Helper I
Helper IIf I go to Transform data, I can not edit my Calender, it is not even there, only my other tables.