Forum Discussion
DAX time intelligence question
- Hi there
All the Power BI Servers have their dates set to UTC.
In my blog post below I detail why this is and how to make the required changes to your dataset
https://www.fourmoo.com/2017/10/03/power-bi-did-you-know-all-power-bi-services-servers-are-in-utc-now-how-to-handle-it-for-dates-times/
Hi Anonymous ,
On Power BI Service, the now() function will return the UTC time. I don't think we can set the time zone on Power BI Service. To get the correct local time, we can add time different in your DAX formula, or use Power Query to get the local time zone datetime.
Please refer to below links and that should probably solve your concern:
https://www.youtube.com/watch?v=2kmFfbOeFJg
https://www.youtube.com/watch?v=M1zquwmpnZE
You can also view to the solution of below thread:
https://community.powerbi.com/t5/Service/changing-timezone-of-powerbi-service/td-p/153663
Refer below link:
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
All the Power BI Servers have their dates set to UTC.
In my blog post below I detail why this is and how to make the required changes to your dataset
https://www.fourmoo.com/2017/10/03/power-bi-did-you-know-all-power-bi-services-servers-are-in-utc-now-how-to-handle-it-for-dates-times/