Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Tamillllll
Frequent Visitor

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

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:

Tamillllll_0-1671681537086.png

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:)

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

1 REPLY 1
Anonymous
Not applicable

Have you tried using DateTimeZone.ToLocal?

 

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

--Nate

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors