cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SharonCNE
Frequent Visitor

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?

 

QualificationClass
1Course A
1Course B
1Course C
1Course G
1Course H
1Course I
2Course A
2Course B
2Course C
2Course D
2Course E
2Course F
3Course A
3Course B
3Course C
3Course J
3Course K
3Course L

 

NameClassComplete Date
JayneCourse A2/10/2021
JayneCourse B2/10/2021
JayneCourse C2/10/2021
JayneCourse D 
JayneCourse E 
JayneCourse F 
JayneCourse G3/15/2021
JayneCourse H3/15/2021
JayneCourse I3/15/2021
JayneCourse J 
JayneCourse K 
JayneCourse L 
JayneCourse M 
JayneCourse N 
JohnCourse A2/10/2021
JohnCourse B2/10/2021
JohnCourse C2/10/2021
JohnCourse D 
JohnCourse E 
JohnCourse F 
JohnCourse G 
JohnCourse H 
JohnCourse I 
JohnCourse J6/2/2021
JohnCourse K6/2/2021
JohnCourse L6/2/2021
JohnCourse M 
JohnCourse N 
1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

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 ) )

 

AlexisOlson_0-1631632704540.png

 

View solution in original post

1 REPLY 1
AlexisOlson
Super User
Super User

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 ) )

 

AlexisOlson_0-1631632704540.png

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.