Calendar in Spanish

[mariases94]

Hello!

I don't know why my Calendar Table is in English. I've changed the lenguage and I've restart Power BI, and the information still appears in English.

  

Can someone help me, pleaseee??

Thanks!!

[mariases94]

@goncalogeraldes 

Gracias Gonçalo!! Me ha funcionado!

Pero ahora me salen los meses en minúscula y necesito que la primera letra de cada mes me salga en mayúscula. ¿Como se hace?

Gracias!!!!

[goncalogeraldes]

No problem @mariases94 , you can do it like so:

Mes = 
var _date = FORMAT( 'Calendar'[Date_Key], "mmmm", "es-es")
return
UPPER(LEFT(_date, 1)) & RIGHT(_date, LEN(_date) - 1)

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[goncalogeraldes · Accepted solution]

Hello there @mariases94 ! If you are doing it in Power Query with the Date.DayOfWeekName() function, you can add an extra optional parameter to format it as a Spanish word like so:

If you are doing it with DAX, you can do so with the FORMAT() function additional parameter for "locale name":

Mes = FORMAT( [Date], "mmmm", "es-es")

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes