Forum Discussion
Change month name language
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
)
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
)
Thanks for the info. The regional setting didn't work. So I have used a calculated column.
Mes = SWITCH(MONTH('table[fecha]);1;"Enero";2;"Febrero";3;"Marzo";4;"Abril";5;"Mayo";6;"Junio";7;"Julio";8;"Agosto";9;"Septiembre";10;"Octubre";11;"Noviembre";12;"Diciembre")
Cool , Let me know if any help
The 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
Hello,
I am using SSAS, and I swear to god, I am using different language codes and the month always appears in Polish.
