Forum Discussion
Convert data from UTC to Local Time
If your input is in DateTimeZone format already, then you might be able to use DateTimeZone.ToLocal.
If not, then you can probably use DateTime.AddZone as explained here:
https://community.powerbi.com/t5/Desktop/Convert-utc-to-local-time-zone-using-Power-Query/td-p/45533
AlexisOlson Hello Alexis,
Not sure I got it correct or not, based on my understanding,
#datetimezone(https://docs.microsoft.com/en-us/powerquery-m/sharpdatetimezone)
requires a predefined offset-hours + offset-minutes
The complicate case here is that offset-hour is not a fixed value, it changes twice a year... same applies to DateTime.AddZone
Hi Anonymous ,
Please review the following documentations, hope they can help you.
Convert UTC to Local Time with Daylight Savings Support in Power BI
4 Ways to Fix Date Errors in Power Query + Locale & Regional Settings
Local date formats in Power BI
Best Regards
Rena
Thank you for your reply.
Basically the ideas of the post is still manually define when to switch the exact hours on difference.
The complexity comes from first sunday of certain month...
there is a big chuck of logical code written to detect first sunday of some month.
I know how to achieve just think it would be nice to add a easier timezone convert function, which can be a more elegant method.