Forum Discussion

JayZee70's avatar
JayZee70
Icon for Helper I rankHelper I
1 year ago
Solved

Upper 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 ...
Need Help
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    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))
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    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))
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    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:

     



Sergii24's avatar
Sergii24
Icon for Super User rankSuper User
1 year ago

Hi JayZee70, I believe you're right, it seems to be somehow related to your PC settings. In my case, this simple formula provides a desired result:

 

However, once you use Format() fucntion your value becomes a text, not date anymore. Therefore you can use any text transormations to obrain the necessary result:


Here is a code for copy-paste:

 

Week Day Capitalize First Letter = 
VAR _WeekDay = FORMAT( WEEKDAY( 'Table'[Date], 1 ), "DDDD" )            //obtain the day of week
RETURN
    UPPER( LEFT( _WeekDay, 1 ) )                                        //get the first letter from a variable and capitalize it
    &                                                                   //concatentate with
    RIGHT( _WeekDay, LEN( _WeekDay ) - 1 )                              //the rest of the word, which is length of a word without a first letter

 

 

Good luck! 🙂