The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi everybody,
I would like to know how I change the name of the dates (days,months...) from english to spanish.
I´m using this formula, for example, to create a new column and I would like to show the names in spanish:
Month Name = FORMAT(DimFecha[FECHA];"MMMM")
My regional setting in Power Bi Desktop is Spanish.
Any help, please ?
Solved! Go to Solution.
Hi
If you use the Add Column from Date - Month - Name of Month via the Query Editor you will get the month name in spanish.
If you add a column via the field list you will get the month name from your windows regional settings.
I recommend the translation via the Query editor - where you in the optional argument can specify the language.
https://msdn.microsoft.com/en-us/library/mt736915.aspx
br
Erik
Hi
If you use the Add Column from Date - Month - Name of Month via the Query Editor you will get the month name in spanish.
If you add a column via the field list you will get the month name from your windows regional settings.
I recommend the translation via the Query editor - where you in the optional argument can specify the language.
https://msdn.microsoft.com/en-us/library/mt736915.aspx
br
Erik
Thanks @donsvensen!
I´m using this column in a table that doesn´t come directly from a query, so I can't use the Query editor.
The table comes from the distincts dates of another table. After that I want to create the column "Name of the month", "Name of the Day", ...
Thanks for the explanation.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
137 | |
106 | |
105 | |
73 | |
59 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
88 |