DAX Date-table not culture/language aware

[Daniel71]

I've created a Date-table with DAX in a tabular-model in Azure Analysis Service with Visual Studio 2017.
I develop in English (Culture en-US) but the reports are for Ducth-collegeas (Culture NL-nl). 
In the tabular-model is a Dutch-translation for the labels.

This translation of the labels works bij using PowerBI (Dutch) but the description in the date-table doesn't  change.   Monthname, Dayname etc etc.

Example  "DayOfWeek"; FORMAT ( [Date]; "dddd" );   shows Wednesday instead of Woensdag for the the Dutch of Mittwoch in German

[Daniel71]

I think I know what te problem is.
When you create the Date-table in DAX in PowerBI the values get recalculated.

When you make the Date-table in Azure Analyses Services (English) in a tabular model. AAS sees this as a column in a table and 'freezes' the values because it isn't a measue.

I believe it's not possible to 'recalculate' the value to let's see Dutch.

I wander how enterprises like with different stores solve this issue!

@GuyInACube 

[avanderschilden]

Hello,

Did you test how Wednesday is displayed in the report when consuming it on powerbi.com with explorer language set to Dutch? I remember one of my colleagues had his Chrome set to Dutch language, and everything was in Dutch on powerbi.com.

Regards,

Adrian

[Daniel71]

Hello,

I'm not using Powerbi.com yet but de Ducth desktop-version.

Al labels are translated conform my translation-file to Ducth except the 'values' in the table.

Gr Daniel