Forum Discussion
Countrows and filtering
Anonymous , You are using date table, so you have active relation between date of Date table and leave date
measure =
var _min = EDATE(EOMONTH(today(),-1),-12)+1
vat _max = EOMONTH(today(),-1)
return COUNTROWS(CALCULATETABLE('Date',FILTER('Date','Date'[LTM Dates] <= _max && 'Date'[LTM Dates] >=_min),FILTER('Staff Data','Staff Data'[Vol. Leaver]= "yes")))refer how to handle two dates
Anonymous , You are using date table, so you have active relation between date of Date table and leave date
measure =
var _min = EDATE(EOMONTH(today(),-1),-12)+1
vat _max = EOMONTH(today(),-1)
return COUNTROWS(CALCULATETABLE('Date',FILTER('Date','Date'[LTM Dates] <= _max && 'Date'[LTM Dates] >=_min),FILTER('Staff Data','Staff Data'[Vol. Leaver]= "yes")))
refer how to handle two dates
Thanks. I had an extra problem with TRUE/FALSE values but managed to sort it thanks to the extra link you shared.