Convert datetime from UTC to EST

[PBI_newuser]

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?

[Pragati11 · Accepted solution]

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