Forum Discussion
DAX time intelligence question
Hi, I have been troubled by this problem for a long time. So my data source is a data table from a MSSQL server and my data is updated in the real time. Now I want to get my today's sale...
- 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 ,
As you can see, my local time is 8 hours ahead of UTC time, so when UTC time is 4 pm, my local time is already the next day.
So I created a condition column as follows and add this column to the slicer.
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.