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:
Super UserHi 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))
Helper IThank you Geraldo!
It works great.
- JayZee70
...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?
- Bibiano_Geraldo
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
You're welcome
- JayZee70
Thanks again. Sometimes the easiest things can be hard to see.