S Ng
Active Member
Joined: Apr 4, 2019
Follow
RE: Date format difference in Pivot table vs PowerQuery table
ok, I managed to figure this out. I had updated the locale within the date column in power query to be English (Australia) and it looked right. Ho...
6 years ago
RE: Date format difference in Pivot table vs PowerQuery table
Region is Australia The odd thing is - excel is treating the data like the dd/mm/yy format so i'm not sure how/where in the process its flipping th...
6 years ago
Replies: 4
Views: 131