Forum Discussion

amgelain's avatar
amgelain
Regular Visitor
2 years ago
Solved

First letter capitalized

Hello,   In the calendar table, I need the first letter of the month in capital letters. I created a calculated column and tested several functions without success.   Any suggestions to solve thi...
capitalized
  • speedramps's avatar
    speedramps
    2 years ago

    The FORMAT mmmm is returning lower case because of your langauge settings.
    Different countries have different rules:-
     Click to learn about language settings  

     

    en: September

    es: septiembre

    fr: septembre

    de: September

    This will display months with capital first letter

    Month = UPPER(LEFT(FORMAT('Calendar'[Date],"mmmm"),1)) & MID(FORMAT('Calendar'[Date],"mmmm"),2, LEN(FORMAT('Calendar'[Date],"mmmm"))-1)

     

    Please now click the thumbs up and the [accept as solution] button.  Thank you.

     

speedramps's avatar
speedramps
Icon for Super User rankSuper User
2 years ago

In your calanedar table add a calculate column~

Month name = FORMAT('Calendar'[Date],"mmmm")

 

Thanks for the clear description of the problem.  I wish everyone did that!

Remember we are unpaid volunteers. So please click the thumbs up and the [accept as solution] button to leave kudos. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

If you quote speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.

Please now click the thumbs up and the [accept as solution] button.  Thnak you.

  • amgelain's avatar
    amgelain
    Regular Visitor
    2 years ago

    Hello! Previously, this was the formula I created. As shown in the image, the month starts with a lowercase letter.

    What can it be?

     

    Grateful.