Desktop refreshing at 4:00 pm rather than 12:00 midnight

[Shane86]

im assuming this has something to do with UTC but im still stumped. i have relitive date filters on my dashboard that filters to the current month. At the end of the month at 4:00pm it updates to the next month. this is frustrating when were often down to the wire to get orders out and want to see where revenue is hitting but the dashboard has already updated to the next month. im hoping it a simple fix and not something where i have to link all the dates to a new timezone or something. any help is greatly appreciated!

[lbendlin · Accepted solution]

Nopes, not a simple fix. Time zones are hard.

https://radacad.com/solving-dax-time-zone-issue-in-power-bi

[Shane86]

Thanks for the reply!

I was hoping it wouldnt come to that. so do i just create another column in the data and do a dax formula to the original date and add/subtract hours to get the desired time? Thats how i understand the "Method 1" in the link you sent at least

[lbendlin]

yes but that will only work if all your users are in the same timezone.