Forum Discussion
Helper IUpper case in the Calender Weekday name
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:
Helper IHey!
Thanks, it worked out fine!
How do you code it if you want to do the same thing to Months?
I have a column "Month" but that is simply in number, I want the months by name.
BR / Jesper
Super UserCan you share a column containig data and dax used to create that column?
- JayZee70
- Bibiano_Geraldo
Hi JayZee70 ,
to get Month name you can use the following DAX:Month Name = FORMAT('Calendar'[Date],"Mmmm")This will result in something like this:
- JayZee70
Yeah, 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.