Forum Discussion
Relative Dates - more options
Hi I woudl like to use the releitive date filter to say is not in the last calendar week (for example), but I can only filter on inclusions, not exclusions. Does anyone know if there is a way t...
v-chenwuz-msft
Community Support
Community SupportHi Anonymous ,
Maybe you can just create a measure to calculate the result via
not attend =
var _lastweekstart = today() - weekday(TODAY(),2)-7
var _lastweekend = _lastweekstart+6
return
COUNTROWS(FILTER('calendar',[Date]>=_lastweekstart&&[Date]<=_lastweekend &&[status]="not attended"))
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for this. there is no field to hold a status of "not attended"
I have a table that shows when appointments were scheduled to be attended, and another table that shows when they were attended.
Appointments maybe scheduled many times, but only attended once.
The question I wish to answer is how many were scheduled for last week, but not attended (because they were rescheduled).
scheduled date in last week, attended date not in last week.