Forum Discussion
Upper 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:
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.
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))
Thank you Geraldo!
It works great.
...now I am just having touble sort the axel in the chart so that it will show Jan-Dec.
Now it sorts in alphabetical order....
Of course, if I use my calender "Month" or my created Month it sorts correctly via the 3 dots in the upper right corner of the chart.
Any idea how to fix this?
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:
You're welcome
Thanks again. Sometimes the easiest things can be hard to see.