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