Converting data saved in UTC time to multiple time zones and taking into account day light savings

[Ikeumlaut]

I've tried to look for a solution for my problem but cannot really wrap my head around this.

I have data from two different times zones, all data is saved in UTC. I want to convert the times to the correct time zone and take into account day light time savings.

This how the data is saved:

User	Time (UTC)	Value	TimeZone
A	20.3.2018 12:34	1	EET
A	20.3.2018 18:08	1	EET
A	20.3.2018 19:42	0	EET
B	20.3.2018 9:00	1	PST
B	20.3.2018 10:05	0	PST

I would like to have it to convert into this format:

User	Local time	Value
A	20.3.2018 14:34	1
A	20.3.2018 20:02	1
A	20.3.2018 21:42	0
B	20.3.2018 16:00	1
B	20.3.2018 17:05	0

How do I do it so that also day light time savings work and that times do not change if my report is opened in another time zone?

Thanks!

[v-jiascu-msft]

Hi @Ikeumlaut,

It seems adding a column like this will work.

Localtime =
IF (
    'Table1'[TimeZone] = "EET",
    [Time (UTC)] + TIME ( 2, 0, 0 ),
    IF ( 'Table1'[TimeZone] = "PST", [Time (UTC)] + TIME ( 7, 0, 0 ), BLANK () )
)

Best Regards,

Dale

[Ikeumlaut]

Hey, @v-jiascu-msft,

does it take into account daylight savings? On Sunday EET will change to summer time.

Thanks for the help!