A pretty satisfied workaround we've found is using a parameter in the DATEADD function to calculate the "time shift" difference to overcome the UTC auto added difference:
So, for example if you have a column called "Start Time" and you want to add 3 hours to all its rows, do the following:
1) Define a parameter such as "time_shift" and define its value to be an integer with the value=3.
2) Use this formula:
DATEADD('hours', [time_shift],[Start Time])
The advantage using a parameter is that it's affecting all formulas it's being used in.
Hope it helps,
How do you handle daylight savings? Does anyone have a formula that will adjust for DST as well? I can try to write one but figured I'd ask first.