Forum Discussion
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 this problem?
Thank you very much.
The FORMAT mmmm is returning lower case because of your langauge settings.
Different countries have different rules:-
Click to learn about language settingsen: September
es: septiembre
fr: septembre
de: September
This will display months with capital first letterMonth = 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.
5 Replies
speedrampsSuper User
The FORMAT mmmm is returning lower case because of your langauge settings.
Different countries have different rules:-
Click to learn about language settingsen: September
es: septiembre
fr: septembre
de: September
This will display months with capital first letterMonth = 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.
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.
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.
