Converting UTC to Various Timezones with and without daylight savings

[moesteez]

Hi,

I have a bit of a complicated timezone problem that I cant get my head around. I have a bunch of data in various timezones while all my data is coming in as UTC. Some timezones have daylight savings, some do not. The ones that dont are easy enough to just add and minus from the time and Ive seen blog posts explaining how to change from UTC to a local time,  but how can I convert a UTC time to someone elses timezone that also accounts for changes in daylight savings?

Thanks 

[v-lili6-msft]

hi @moesteez 

You could refer to this similar post for your refer to:

https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/m-p/56337

keep a UTC column for the datetime column in the datasource.

Regards,

Lin

[moesteez]

Thanks @v-lili6-msft but this post looks like it is just adding to the original time regardless of daylight savings.. Am I wrong in thinking that? It doesn't look like it's taking into account whether that timezone is currently in or out of daylight savings?