Forum Discussion
Solved
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...
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")
Baskar
Resident Rockstar
Resident RockstarCool , Let me know if any help