Forum

Power Query UTC Tim...
 
Notifications
Clear all

Power Query UTC Time to Eastern Time

2 Posts
2 Users
0 Reactions
152 Views
(@mclaprood)
Posts: 1
New Member
Topic starter
 

I have a data set that is set (call logs) that are set at UTC time as default. However, I'm trying to group call logs by time so I can output the time of day we have the highest instance of different call types.

I'm having trouble finding a way in Power Query to change the time zone from the data set to Eastern time or calculate  to + or - hours correctly. 

Does anyone have suggestions?

Thank you!

 
Posted : 07/09/2019 2:32 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Michelle,

Have you tried the DateTimeZone Functions?

Mynda

 
Posted : 07/09/2019 7:21 pm
Share: