Help between formatting US and UK Dates

[jcarville]

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.

[BhaveshPatel · Accepted solution]

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

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

[OwenAuger · Accepted solution]

@jcarville

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/

https://blog.crossjoin.co.uk/2015/05/25/working-with-international-date-and-number-formats-in-power-...

[BhaveshPatel · Accepted solution]

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