Forum Discussion
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 ...
Hi Anonymous ,
check the post below from RADACAD they present a couple of options to make this changes.
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
Maybe one can fit your needs.
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
check the post below from RADACAD they present a couple of options to make this changes.
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
Maybe one can fit your needs.