Search This Blog

Thursday, May 28, 2020

Changing Time Zones in Power Query

When you get date and time values from another systems, sometimes it is in a time zone that is different from yours. For example you might get a field that has a date/time/timzone in UTC or GMT format, but you need to doanalysiss in Western time. How do you convert the timezone? You could actually do the calculations and offset it by adding or subtracting hours to the UTC value. Switching time zones gets more complicated if you have to deal with daylight saving time. You'd have to find out which zonehour had daylight saving applied and which did not. How you handled the time zones begins by setting or configuring an initial time zone in Power Query for the date/time value.

No comments:

Post a Comment