Convert DateTime to Local Time

[datapal04]

Hello,

I have a data source as Dataverse. I am looking to convert a column that is Date/Time in UTC to Date/Time in EST. How can I achieve this? Preferably, I am looking for a solution that will take care of Daylight Savings Time.

Thanks in advance!

[Anonymous · Accepted solution]

Hi @datapal04 ,

Here're some solutions in the following links, please kindly refer to

Convert UTC date format into local time format in Power BI - Scaleable Solutions

Convert Date/Time in UTC to Local Time with Daylight savings

Convert UTC to Local Time in Power BI - IntelliTect

Convert UTC datetime to local time zones in Power Query – Curbal

Best Regards,

Stephen Tao

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