Forum Discussion
Solved
Trouble with Date Filter
Hi everyone I'm having a trouble with a Date Segmentation in my table. I needed to build a report that I would be able to filter Date Period and compare my data among them, so I made 3 calend...
The Power BI service runs on UTC time while Desktop is using the time zone of where you're located. I've had to deal with this in the past reporting measures "for today" (users, etc.) which always reported incorrectly after midnight UTC. How I dealt with it was essentially as follows inside the measure (sorry I don't have access to the DAX anymore)
- Variable for UTCTODAY()
- Variable for where you're located UTCNOW() - (NN/24) with NN being the number of time zones you are ahead of or behind UTC time
- Compare the two and if the dates are the same handle one way. If different handle appropriately.
Hope this helps! 😁
Hi!! Thank you so much for your help
I think that I found the problem, It's a time zone problem!
When I post the report on Power BI Service and use the filter for Nov 1st the information there is corect, but on Power BI Desktop the information remains incorrect.
If you know how can I fix it on Power BI Desktop too, would you help me?