Search found 2 matches

by cjonesreadle
Fri Aug 24, 2018 10:51 am
Forum: PowerPivot/DAX
Topic: AUS Date Chnged to US in Power Pivot Data Model
Replies: 3
Views: 1251

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

Hi Matt I have been using Power Query to pull the data into the Data model and went through and changed the Locale to Australia. This has helped with the pivot tables how ever when I change the tables to Cube formulas, the date change back to the US formatted dates again. I have included screen shot...
by cjonesreadle
Thu Aug 09, 2018 4:29 pm
Forum: PowerPivot/DAX
Topic: AUS Date Chnged to US in Power Pivot Data Model
Replies: 3
Views: 1251

AUS Date Chnged to US in Power Pivot Data Model

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 w...

Go to advanced search

cron