Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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-...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.