Measure with TODAY() as a filter isn't working

[vicky_]

Hello!

I've got a measure that I use as a date filter - essentially, i'm trying to show the last 3 working days (excluding today) worth of data:

Measure = 
var a = CALCULATE(
    NETWORKDAYS(SELECTEDVALUE('Calendar'[Date]), TODAY()), 
    KEEPFILTERS('Calendar'[Date])
) 

return IF(a > 1 && a <;= 4, 
    CALCULATE(DISTINCTCOUNT('Orders'[OrdersID]))
)

On my local device, this works as expected. (As in today, is the 2nd March and it's showing me data from the 27th Feb to 1st March) However, when I publish this report, it's still showing me the data from 24th Feb (Friday), 27th Feb (Monday) and 28th Feb. I believe this may be an issue with the time zone of the published report, but I'm not sure how to test or debug this, or possible a caching issue. Does anyone have any suggestions?

And yes, I can use the relative date filter, but my client just wants the last 3 working days, which isn't an option in the filters.

[amitchandak · Accepted solution]

@vicky_ ,

https://www.linkedin.com/pulse/power-bi-service-time-differences-how-fix-aaron-watsky/

https://bondconsultingservices.com/2022/01/26/power-bi-date-and-time-in-desktop-vs-service/?utm_sour...

https://support.helpshift.com/kb/article/how-do-i-set-my-timezone-in-power-bi/

[vicky_]

Legend! Thank you