Forum Discussion
Helper IIcalendar month names
Hi, i am working in a Dutch company where this is also the language used in reports. So i need reports to be in Dutch language.
All my regional settings are in Dutch. The Power bi menus are in Dutch. But still, if i use
*format (month (kalender[date]) , "mmmm")*
in my calendar table, it returns English months instead of Dutch....how to change this?
Oh and it also only gives back DEcember for first month from "date" field, and January for month 2 till 12....
Greg_Deckler
never mind Greg, i solved it now with the SWITCH function to get my Dutch month names.
4 Replies
- Greg_Deckler
Community Champion
bvdm1980 That seems like a bug as the FORMAT function supports other languages. FORMAT function (DAX) - DAX | Microsoft Learn
That said, if the report is going to be displayed in the Service, then the easiest "fix" is to just use the native translation of the browser.
bvdm1980Greg
First, thanks for your reply! much appreciated.
Allthough it didn't solve it. Here is example of what it now looks like. I have a DATE column, of which i can't change the name to Dutch DATUM , so i created a DATUM column as well based on DATE.
Then the month number, and then i want the long month name (januari / februari etc, being dutch names)So you can see the DAX i used to create the long month name. As said its the English name, where al settings are in Dutch. And its the wrong name too, as December is put to month 1, while January is put on the other months.
I used this DAX before but never experienced this tbh. So i have no clue where to look for the solution.
Well i can create a new table with month numbers and month names in dutch , and then somehow link this to calender. But that should not be the way to go imo.- bvdm1980
Greg_Deckler
never mind Greg, i solved it now with the SWITCH function to get my Dutch month names.
Hi,
I came acros this same problem but didn't want to use a switch function.
Solved it by including the Dutch locale in the format parameters, refer to line 14:
