Forum Discussion
First letter capitalized
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.
Super UserThe 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.
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