Forum Discussion
Skilled SharerHelp between formatting US and UK Dates
Has anyone came across a good article about how PowerBI works with dates in terms of UK and US dates?
Being based in the UK and regularly working with US dates proves to be difficult at times as US dates are not always recognised and converted to UK dates.
Hi There,
You can change the locale settings in the Query mode. For More info, Please refer to this link for demo.
Thanks & Regards,
Bhavesh
Here are some other postsI have come across, in the context of Power Query but should still be relevant:
http://www.excelguru.ca/blog/2015/07/08/fix-date-errors/
3 Replies
- BhaveshPatel
Super User
Hi There,
You can change the locale settings in the Query mode. For More info, Please refer to this link for demo.
Thanks & Regards,
Bhavesh
- OwenAuger
Here are some other postsI have come across, in the context of Power Query but should still be relevant:
http://www.excelguru.ca/blog/2015/07/08/fix-date-errors/
- jcarville
Hi guys, these articles are exactly what I was looking for, thanks so much!
I have marked both as the solution as they were all really helpful.
