Forum Discussion
Date fields not reflecting true local time
Hey shanfaulks ,
A couple of reasons for this can be the date/time of the data itself (ie. you are in NZ, but the data is in the US, so it looks "off") or, your tenant could be set to UTC time and not your time in the service. And, therefore, "Now()" can be interpreted as UTC time and/or as the time of your tenant, and not where you are.....
And, displaying the time SHOULD be in your own time based on your computer but I know that doesn't always work, particularly within the visuals themselves. I have three links that might be of assistance:.
1. THis is the M code page for the DateTimeZone functions: DateTimeZone functions - PowerQuery M | Microsoft Learn
2. This is another community request over the same idea: Solved: Convert UTC to client time zones? - Microsoft Power BI Community
3. This is a blog about the topic: Dynamic time zone conversion using Power BI – The White Pages (tygraph.com)
Thank you, the links you provided weren't useful for this issue as I had already tried all the functions mentioned. But thanks anyway.