Checking which machinery is free - I have table with jobs containing a date [Start] and a Vehicle [Ref from the Vehicle Table [Vehicle]]. I want to know which Vehicles haven’t been allocated to a job on a specific day. Am thinking that it should be something like AND(In[Vehicle], look in the job list, [Start]=Today()) but cannot quite get how to phrase the formula. Can anyone help please?
Something like VechileTable[Vehicle] - SELECT(TableName[Vehicle],[Start]=TODAY())
If I understand it correctly, that will give me a list of vehicles that have been allocated. It’s the a way to get a list of the others? That is, those in the vehicles table that do not have jobs on a given day?
This will do exactly that because of “-”. Read the whole list - assigned vehicles.