@DoctorYSG you can use the DateTimeZone.SwitchZone function. Here are the steps to convert the time zone from EST to GMT. Kindly FOllow these steps:
1 - Convert the date and time values to a datetimezone value using the DateTimeZone.From function.
2 - Use the DateTimeZone.SwitchZone function to change the time zone from EST to GMT.
3 - Convert the datetimezone value back to a date and time value using the DateTimeZone.ToLocal function.
let
Source = <your data source>,
#"Converted to DateTimeZone" = Table.TransformColumns(Source,{{"Date", each DateTimeZone.From(_, "Eastern Standard Time")}}),
#"Switched Time Zone" = Table.TransformColumns(#"Converted to DateTimeZone",{{"Date", each DateTimeZone.SwitchZone(_, 0, -5)}}),
#"Converted to Local Time" = Table.TransformColumns(#"Switched Time Zone",{{"Date", each DateTimeZone.ToLocal(_)}})
in
#"Converted to Local Time"
The code above assumes that the date and time values are stored in a column named Date.
Ensure to replace <your data source> with the name of your data source.
You can also Watch Curbal YouTube on how to Convert UTC datetime to local time zones in Power Query
https://www.youtube.com/watch?v=M1zquwmpnZE
Let me know if this works for you. @ me in replies, or I'll lose your thread!!!
Note:
If this post helps, please consider Accepting it as the solution to help others find it more quickly. OR
If my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
Best Regards,
Dallas.
