Forum Discussion
hectormungo
9 years agoFrequent Visitor
Change month name language
Hi. I have made some reports with Power BI Desktop (English version) and I added a column in every report with the formula: MonthName = FORMAT( 'date_field'[fecha]; "mmmm" ) This gave me the name o...
- 9 years ago
Two ways
1. Go to file > options and settings > options > regional setting > select spanish
Save and close it . Then open
if it will not help u . U have to create one calculated column to replace the old column with same name.
Column = var Month_Name = FORMAT( 'date_field'[fecha]; "mm" )
return switch ( true(),
Month_Name=1, "Jan in Spanish"
.
.
.
etc
)
austinsense
Impactful Individual
9 years agoThe FORMAT() function in DAX works a lot like the TEXT() function in Excel - maybe this helps http://excelribbon.tips.net/T011782_Specifying_a_Language_for_the_TEXT_Function.html
Anonymous
9 years agoNot applicable
Hello,
I am using SSAS, and I swear to god, I am using different language codes and the month always appears in Polish.