MINX(
FILTER(
'Contract',
AND(
EDATE('Contract'[First_Date_in_service],3) < MAX('Reference date filters'[Date]),
OR(
Contract[Date_out_of_service] >= MIN('Reference date filters'[Date]),
Contract[Date_out_of_service] = BLANK()
)
)
)
,1
)
Type Meting
... View more