Forum Discussion
Convert datetime from UTC to EST
Hi, the datetime column imported from Salesforce has automatically changed to UTC timezone as default.
How to convert it to EST by considering the Daylight Saving too?
HI PBI_newuser ,
There are few existing threads on this forum for this question:
https://community.powerbi.com/t5/Desktop/Custom-Query-Function-to-convert-UTC-to-EST/td-p/1106780
https://community.powerbi.com/t5/Desktop/Converting-UTC-to-EST/m-p/1253745
You can also check following blog on handling timezones in Power BI:
https://powerbitalks.com/2020/08/convert-utc-into-local-time-zone-po.html
Thanks,
Pragati
1 Reply
HI PBI_newuser ,
There are few existing threads on this forum for this question:
https://community.powerbi.com/t5/Desktop/Custom-Query-Function-to-convert-UTC-to-EST/td-p/1106780
https://community.powerbi.com/t5/Desktop/Converting-UTC-to-EST/m-p/1253745
You can also check following blog on handling timezones in Power BI:
https://powerbitalks.com/2020/08/convert-utc-into-local-time-zone-po.html
Thanks,
Pragati