Convert UTC to EST time

Question

Hi&nbsp;&nbsp;I have a below column in UTC&nbsp;&nbsp;I would like to convert the above UTC into EST timezone&nbsp;I tried the below code&nbsp;DateTimeZone.SwitchZone([[DateofReading]],-5)Getting below error&nbsp;&nbsp;&nbsp;I checked other posts but had no success. Can anyone advise?

amitchandak · Answer

bourne2000 , refer this 
https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337
&nbsp;
or addTimezone
https://docs.microsoft.com/en-us/powerquery-m/datetime-addzone

anonymous · Answer

Hi&nbsp;bourne2000,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

Convert UTC to EST time

2 Replies

Related content

REAL TIME TILES AUTO CONVERT TIMESTAMP TO UTC

Convert UTC to client time zones?

Convert UTC Date to Central Standard Time

Easy method to convert UTC time to local time

how to convert date time UTC to IST format in powerbi