Converting UTC Time(24 hr) to local time using power query.

[Tamillllll]

Hi,

Can I please get help with below query,

The column "Scheduled" is in UTC in 24 hr format, How can I convert this into local time(Sydney)?

(Most of the posted solutions were for AM/PM format on;y). Not sure how this can be converted.

Snip of the Column:

I would like to do this using power query, as I would be performing few steps with date after the conversion.

(With column tool, we can convert this to AM/Pm format and convert this into local format. However would not prefer that option.)

Thanks:)

[watkinnc · Accepted solution]

Have you tried using DateTimeZone.ToLocal?

https://learn.microsoft.com/en-us/powerquery-m/datetimezone-tolocal 

--Nate