How to find people that do not hold a qualification
We have a data set where staff are trained and hold a qualification for a finite period of time. I have created a data model with a fact table that holds one record per person (Staff) per qualification (Training Type) per day that the qualification is valid for. Please see the attached table view.
I can now produce charts that show many staff hold each type of qualification within given date ranges.
The client also wishes to see which staff did NOT hold a particular qualification (or group of qualifications) within a given date range. I would prefer not to add more records to the fact table as I already have 10's of millions of rows and running out of memory.
Is there a set analysis expression I can use? It is not as easy as selecting records that do not equal a Training Type as staff members hold multiple qualifications at a given point in time.
Message was edited by: Michael Fenton
Uploaded sample app