Date translations using calendar auto

[Thomasnplus]

Hi guys,

New to DAX and POWER BI, so forgive me if this is a stupid question

I'm creating my date table using the following DAX statement:

Dates =
VAR basecalendar =
CALENDARAUTO(12)
RETURN
GENERATE(basecalendar;
VAR BaseDate = [Date]
VAR YearDate = YEAR (basedate)
VAR MonthNumber = MONTH (BaseDate)

RETURN ROW(
"Day"; BaseDate;
"Year"; YearDate;
"Month Number"; MonthNumber;
"Month"; FORMAT(BaseDate; "MMMM");
"Year Month"; FORMAT(BaseDate; "MMM YY")

)
)

However, all my month names are in english and i need them to be danish. Is there any solution to this?

Thanks,

//Thomas

[solvisig]

It depends on the language you have selected in the options:

and then when you publish to the service it depends on the language you have selected in the browser and in the powerbi settings:

[alexei7]

Hi Thomas,

Maybe the following is useful depending on what you're trying to do:

https://docs.microsoft.com/en-us/power-bi/supported-languages-countries-regions

Hope that helps,

Alex