Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to 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.
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.
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
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
59 | |
20 | |
12 | |
11 | |
10 |