Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
amgelain
Regular Visitor

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.

1 ACCEPTED SOLUTION
speedramps
Super User
Super User

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.

 

View solution in original post

5 REPLIES 5
speedramps
Super User
Super User

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.

 

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

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
Super User
Super User

In your calanedar table add a calculate column~

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

 

speedramps_0-1698875388940.png

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.

 

c1cd0cad-eaef-4c3b-8d39-75668e633ee7.jpg

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.