I need to keep columns in two time zones in the analysis.
In the old experience, I could do this when I use this formula in the dataset:
parseDate(formatDate(PeriodStartUTC,‘yyyy-MM-dd HH:mm:ss’,‘Europe/Berlin’),‘yyyy-MM-dd HH:mm:ss’).
In the new experience this formula does not change the time zone and we end up with two columns with equal values.
Is there another formula that can be used