Forum Discussion
Solved
Import dates using Locale in Excel
I'm hoping this is a quick fix. On my excel file, the region is set to Australia. When I import this file in Power Query, there are dates in american mm/dd/yy format (unless they cannot be converted)...
What I ended up doing was manually going to the source excel, changing the locale of that file and fixing the dates. Then I went and refreshed the data, which seemed to work.
NewStep=Table.TransformColumns(PreviousStepName,{"your date column name",each Date.From(_,"en-Au")})
Hey, thanks for the reply.
Unfortunately, I can't use Transform as the dates are showing in mixed dd/mm/yy and mm/dd/yy, due to a locale difference.