Convert UTC time to corresponding time zones time?

[akshaydz]

Hi, 

I am looking to populate the client timezone for the utc times I Have. I want to make sure the daylight saving is preserved while converting. Can anybody help me with this please?  

[v-frfei-msft · Accepted solution]

Hi @akshaydz,

Please add another column of UTC values based the Time zone like this.

Then we can add a new custom column and get the result.

Time + = DateTimeZone.SwitchZone([#"UTC-time"],[#"UTC+"])

For more details, please check the pbix as attached.

https://www.dropbox.com/s/ix7xscsxjpqv33a/Convert%20UTC%20time%20to%20correspondin.pbix?dl=0

Regards,

Frank

[v-frfei-msft]

Hi @akshaydz,

Does that make sense? If so, kindly mark my answer as a solution to close the case please.

Regards,

Frank