Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
moesteez
Helper I
Helper I

Converting UTC to Various Timezones with and without daylight savings

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 

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.