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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!