Checking which machinery is free - I have tab...

[Marlene_William]

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?

[Aleksi_Alkio]

Something like VechileTable[Vehicle] - SELECT(TableName[Vehicle],[Start]=TODAY())

[Marlene_William]

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?

[Aleksi_Alkio]

This will do exactly that because of “-”. Read the whole list - assigned vehicles.

[Marlene_William]

@Aleksi_Alkio oh ok. Thanks very much indeed