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.
