Forum Discussion
Solved
Time Zones
Hi all I have a problem with timezones. Our SQL server logs time in UTC, and our local machines are in UTC +1 (or +2 depending on DST). So right now when I get data with time in it I know tha...
Hi PeterGarant,
Based on my test, you can just use the formula below to add a custom column to get the expected Local time. :smileyhappy:
= DateTimeZone.RemoveZone([CreatedUTC]) + #duration(0, DateTimeZone.ZoneHours([CreatedUTC]), 0, 0)
Regards
That could be a way of doing it yeah, thanks for the idea. But I'm still wondering why there isn't a function to tell PBI what the time in a column is.
But guess that could come in a future release.
Hi PeterGarant,
Based on my test, you can just use the formula below to add a custom column to get the expected Local time. :smileyhappy:
= DateTimeZone.RemoveZone([CreatedUTC]) + #duration(0, DateTimeZone.ZoneHours([CreatedUTC]), 0, 0)
Regards
That works like a charm, thank you very much.