topic Re: First letter capitalized in DAX Commands and Tips

First letter capitalized

amgelain — Wed, 01 Nov 2023 20:59:06 GMT

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.

Re: First letter capitalized

speedramps — Wed, 01 Nov 2023 21:50:22 GMT

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.

Re: First letter capitalized

amgelain — Wed, 01 Nov 2023 23:32:51 GMT

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.

Re: First letter capitalized

speedramps — Thu, 02 Nov 2023 00:02:51 GMT

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.

Re: First letter capitalized

amgelain — Thu, 02 Nov 2023 19:23:14 GMT

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

Re: First letter capitalized

speedramps — Fri, 03 Nov 2023 12:26:55 GMT

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