Page 1 of 1

AUS Date Chnged to US in Power Pivot Data Model

Posted: Thu Aug 09, 2018 4:29 pm
by cjonesreadle
I have added 2 tables to the Power Pivot Model that both have dates included in the data. The dates are in the correct Australian format dd/mm/yy within the excel table, however somehow they have changed to the US format mm/dd/yy with in the Power Pivot Data Model and are displaying in this format when I create a Pivot Table.

I have attached examples for you to see what is happening

Has anyone experienced this before and how can I fix it?

Thanks
Cara

Re: AUS Date Chnged to US in Power Pivot Data Model

Posted: Fri Aug 10, 2018 7:57 am
by MattAllington
I assume your PC is configured for the AUS region. Assuming so, try loading the data using Power Query. In Power Query, there is an option to change the data format "Change Type\Using Locale".

Discover more about my Dax Book.