First letter capitalized

[amgelain]

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 this problem?

Thank you very much.

[speedramps · Accepted solution]

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.

[amgelain]

Hello @speedramps ! Thank you very much for your help. It worked out!

[speedramps]

Thank you for the kudos.
If you need more help then raise a new ticket and quote @speedramps anywhere in the text,  I will then receive an automatic notification and will be delighted to help you again.
Please always try provide example input data as table text (not a screen print) so we can import the data to build a solution for you. You will gain respect and a much quicker and better responses with the more effort put in to describing problems  

[speedramps]

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]

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.