Forum Discussion
Change language for FORMAT function and hierarchy
Hi, I'm developing every report in english because is easier to find tutorials online in that language, I allways code in english. Now I have to plublish a report that uses FORMAT(table[date];"DD...
Hi! MFelix I checked that, is all configured that way, hyerarchies still are in english, format too (My OS is in spanish configured with spanish locale, same as IE).
Anonymous MFelix Ok, this is the current situation, I CAN'T use FORMAT in DAX, because I lost the LOCALE configured before, BUT I CAN use Extract month from date in query editor and it returns the date in spanish. Does that make sense?
Try something like this.
FORMAT('DATA'[Date];"MMMM";"pt-br")