Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Custom Query/Function to convert UTC to EST

Hi all   Struggling with some datetime conversions in PowerBI Desktop and Service. Seen this topic all over the internet with no great answer. I'm hoping someone has a simple function I can invoke ...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    Just do like this.

     

     

    // Modify the parameters of the TIME() function according to the time difference between the two time zones
Measure = UTCNOW() + TIME(8, 0, 0)

     

     

    For example, my current time differs from UTC time by 8 hours, so I add UTC time to 8 hours to get my current time.

     

    Best regards,
    Lionel Chen

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

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

Just do like this.

 

 

// Modify the parameters of the TIME() function according to the time difference between the two time zones
Measure = UTCNOW() + TIME(8, 0, 0)

 

 

For example, my current time differs from UTC time by 8 hours, so I add UTC time to 8 hours to get my current time.

 

Best regards,
Lionel Chen

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