Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

DAX Date-table not culture/language aware

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



Frequent Visitor

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!


Resolver I
Resolver I



Did you test how Wednesday is displayed in the report when consuming it on 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






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

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


Gr Daniel

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.