Converting time zone

[thx]

Hi,

Looking to convert EST time zone to GMT-5 (Jamaica time zone).

During winter GMT = EST

During Summer GMT = CST

Please help. Thank you 

[v-yangliu-msft · Accepted solution]

Hi  @thx ,

GMT is 4 hours behind EST, and you can switch to GMT time zone with TIME (4,0,0).

Here are the steps you can follow：

1. Create calculated column.

Date =
var _date='Table'[closed] + 'Table'[Time]
return
_date + TIME(4,0,0)

2. Result:

Refer to:

Convert Time Zones in Power BI using DAX – NateChamberlain.com

Solving DAX Time Zone Issue in Power BI - RADACAD

Handling Different Time Zones in Power BI / Power Query — The Power User

Best Regards,

Liu Yang

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