power BI find staff absent days

/*
First, create a table with just the Equipment/Staff ID's in it.
Then used the CROSSJOIN() function to create a cartesian product table of the dates 
and the equipment/ staff. 
*/

All Dates And Equipment = CROSSJOIN('calendar','Equipment')

/* 
I then added a column to the "All Dates and Equipment" table:
*/

Was Rented = if(isblank(LOOKUPVALUE('Vehicle Information'[Charge Date],'Vehicle Information'[Charge Date],[Date],'Vehicle Inf