cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jpapador Frequent Visitor
Frequent Visitor

Change time zone hours

I have a date time column that looks like the below.  The problem is, it thinks the zone is currently stored in UTC when the date/time is actually stored in central time.  So how can I change the +00:00 to +06:00.  I understand I can just do a #duration but this wil break when DST changes in the spring.

 

DateTime.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Change time zone hours

@jpapador hope this post is helpful




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

www.perytus.com
(MVP Data Platform)


2 REPLIES 2
Super User
Super User

Re: Change time zone hours

@jpapador hope this post is helpful




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

www.perytus.com
(MVP Data Platform)


Community Support Team
Community Support Team

Re: Change time zone hours

Hi @jpapador ,

 

We can change time to local in power query as below.

 

2.PNGCapture.PNG

 

Regards,

Frank

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.