Forum Discussion

jaykiu's avatar
jaykiu
Frequent Visitor
3 years ago

Issues with Time Calculations(M/Power Query & Dax) in PowerBI Service (EST & UTC)

Hello,   I'm having issues with time calculations due to the difference between server time and local time.   I utilize time calculations in 3 different places: M/Power Query: I have three produ...
Need Help
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, jaykiu 

Power BI is a cloud service, and that means Power BI files are hosted somewhere. Some DAX functions such as Date/Time functions work on system date/time on the server their file is hosted on. So If you use DAX functions such as TODAY() or NOW() you will not get your local date/time, You will fetch server’s date/time.

For a solution to this problem, you can refer to the following documentation:

solving-time-zone-issue-in-power-bi 

 

Best Regards,

Aniya Zhang

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