Forum Discussion
Solved
Summary Qualifications
I need help trying to determine if people are qualified for a task. Qualifications are a combination of different classes/courses that need to be taken, however some classwes/courses can be used in several different qualifications.
In the example I show 3 different qualifications (6 classes each) and also completion dates for 2 users for several classes. How do I show that Jayne is qualified in Qualification 1 but not 3 etc?
| Qualification | Class |
| 1 | Course A |
| 1 | Course B |
| 1 | Course C |
| 1 | Course G |
| 1 | Course H |
| 1 | Course I |
| 2 | Course A |
| 2 | Course B |
| 2 | Course C |
| 2 | Course D |
| 2 | Course E |
| 2 | Course F |
| 3 | Course A |
| 3 | Course B |
| 3 | Course C |
| 3 | Course J |
| 3 | Course K |
| 3 | Course L |
| Name | Class | Complete Date |
| Jayne | Course A | 2/10/2021 |
| Jayne | Course B | 2/10/2021 |
| Jayne | Course C | 2/10/2021 |
| Jayne | Course D | |
| Jayne | Course E | |
| Jayne | Course F | |
| Jayne | Course G | 3/15/2021 |
| Jayne | Course H | 3/15/2021 |
| Jayne | Course I | 3/15/2021 |
| Jayne | Course J | |
| Jayne | Course K | |
| Jayne | Course L | |
| Jayne | Course M | |
| Jayne | Course N | |
| John | Course A | 2/10/2021 |
| John | Course B | 2/10/2021 |
| John | Course C | 2/10/2021 |
| John | Course D | |
| John | Course E | |
| John | Course F | |
| John | Course G | |
| John | Course H | |
| John | Course I | |
| John | Course J | 6/2/2021 |
| John | Course K | 6/2/2021 |
| John | Course L | 6/2/2021 |
| John | Course M | |
| John | Course N |
You can compare the set of classes for each qualification to the set of classes completed by each person.
IsQualified = VAR QualClasses = VALUES ( Quals[Class] ) VAR NameClasses = CALCULATETABLE( VALUES ( Courses[Class] ), NOT ISBLANK ( Courses[Complete Date] ) ) RETURN ISEMPTY ( EXCEPT ( QualClasses, NameClasses ) )
1 Reply
You can compare the set of classes for each qualification to the set of classes completed by each person.
IsQualified = VAR QualClasses = VALUES ( Quals[Class] ) VAR NameClasses = CALCULATETABLE( VALUES ( Courses[Class] ), NOT ISBLANK ( Courses[Complete Date] ) ) RETURN ISEMPTY ( EXCEPT ( QualClasses, NameClasses ) )