Forum Discussion
Convert data from UTC to Local Time
Hello Everyone, I know this issue has been brought up many times. Post in community is mostly rely on simply add | minus some hours https://community.powerbi.com/t5/Desktop/Convert-Date-Column-...
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.