Forum Discussion
Converting time zone
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
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
1 Reply
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