CALENDAR Function giving me english monthnames need to be in danish

[Bokazoit]

This calendar function:

DimDato =

VAR MinDato = DATE(YEAR(MIN(FactFinans[DatoKeyBogføring]))-1,1,1)

VAR MaxDato = DATE(YEAR(MAX(FactFinans[DatoKeyBogføring]))+3,12,31)

RETURN

ADDCOLUMNS (

CALENDAR (MinDato, MaxDato),

"Dato", [Date],

"Måned", MONTH ( [Date] ),

"MånedÅr", FORMAT ( [Date], "mmmm" ) & " " & FORMAT ( [Date], "YYYY" ),

"Måned dato", EOMONTH([Date], 0),

"KvartalÅr", "Q" & FORMAT ( [Date], "Q" ) & " " & FORMAT ( [Date], "YYYY" ),

"Kvartal", "Q" & FORMAT ( [Date], "Q" ),

"Kvartal dato", EOMONTH([Date],if(3-mod(month([Date]),3)=3,0,3-mod(month([Date]),3))),

"MånedNavn kort", FORMAT ( [Date], "mmm" ),

"MånedNavn", FORMAT ( [Date], "mmmm"),

"UgedagNavn", FORMAT ( [Date], "dddd" ),

"Ugedag", WEEKDAY ( [Date] ),

"Dato heltal", FORMAT ( [Date], "YYYYMMDD" ),

"År", YEAR ( [Date] )

)

gives me english names, and every setting is set to danish but still it shows english names?

What am I doing wrong, all settings set to danish also in power bi cloud?

[Bernard]

Calendrier =

ADDCOLUMNS(

CALENDAR(DATE(2018,3,9),today()),

"An",   YEAR([Date]),

"Jour", FORMAT([Date],"dddd"),

"Trim", FORMAT([Date],"Q"),

"Mois", FORMAT([Date],"mmmm","fr-FR"),

"Clé",  FORMAT([Date],"MM-YY"),

"Num_mois", month([Date])

)

il faut ajouter le format de la langue

merci à Power BI Community Administrator <mailer@us.khoros-mail.com>

[v-yalanwu-msft · Accepted solution]

Hi, @Bokazoit ;

if you use data sources that contains data in different Locale format you might want to check the USING LOCALE option available in the query editor.
This allows you to predefine what locale format is each of you datasets and avoid the annoying issues specially with date formats.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Bokazoit]

It does not work, I created a new PBI and the language was set all over to danish, and applied the Date dimension and still it is en english:

[amitchandak]

@Bokazoit , Check these

1. System Calendar and Language setting

2. Regional setting at file level -https://community.powerbi.com/t5/Desktop/Calendar-table-in-english/m-p/1825285

3. Make sure regional setting is applied before the calendar is created.

[Bokazoit]

So delete the calender and recreate is enough?