Forum Discussion
Time zone conversion (please help)
Hello, I am looking to convert Central Time zone to Jamaica (GMT-5) time zone. Jamaica time does not observe day light savings. During winter, it is Eastern Time zone, during summer it is Central t...
Coryanthony OK, so a different take on this. You could do this in DAX. To add/subtract hours in DAX goes like this:
[DateTime Column] + ( 5 * 1/24).
That will add 5 hours for example. Note that this works because Dates and Times in DAX are a decimal number where the integer portion is the number of days since 12/30/1899 and the decimal portion is fractions of a day.
OK, on to the bigger issue, when to apply the +/- different amoutn of hours. The most exact way would be to have a table that stored exactly when daylight savings time began and ended.
Year, DST Start, DST End
2023, 3/12/2023, 11/5/2023
If you just need it to be "close" a more automated method might be to use my equinox calculations here: