Forum Discussion
Convert UTC time to corresponding time zones time?
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?
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
2 Replies
v-frfei-msftCommunity Support
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