cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mariases94
Helper I
Helper I

Calendar in Spanish

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.

 

mariases94_0-1643189036493.png

 

mariases94_1-1643189057124.png  

mariases94_2-1643189074467.png

 

 

Can someone help me, pleaseee??

 

Thanks!!

 

 

1 ACCEPTED SOLUTION
goncalogeraldes
Super User
Super User

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:

goncalogeraldes_0-1643190681136.png

 

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")

goncalogeraldes_1-1643190951589.png

 

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

 

View solution in original post

3 REPLIES 3
mariases94
Helper I
Helper I

@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?

 

mariases94_0-1643191387568.png

 

 

Gracias!!!!

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)

 

goncalogeraldes_0-1643191917146.png

 

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

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:

goncalogeraldes_0-1643190681136.png

 

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")

goncalogeraldes_1-1643190951589.png

 

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

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!