Forum Discussion

Mctwist_720's avatar
Mctwist_720
Regular Visitor
1 year ago
Solved

Power BI - Related / VLOOKUP help

Looking for help - I have two tables data loaded in Power BI:  Table one contains training report data with employee IDs, Training Courses, Training Dates, etc.  Table two contains a roster for all e...
Need Help
  • TomMartens's avatar
    TomMartens
    1 year ago

    Hey Mctwist_720 ,
    creating this measure:

    missing trainings = 
var allTraining = DISTINCT( ALL( 'Training Data'[Training] ) )
var completedTrainings = VALUES( 'Training Data'[Training] )
var missiingTrainings = EXCEPT( allTraining , completedTrainings )
return

IF( COUNTROWS( missiingTrainings ) = 0,
    "completed all trainings", // replace the string with BLANK() if onyy employess with missing trainings need to be listed
    CONCATENATEX( missiingTrainings , 'Training Data'[Training], "|", 'Training Data'[Training] , ASC )
)

    allows me to create this table visual:

    Hopefully, this provides what you are looking for.

    Regards,
    Tom

TomMartens's avatar
TomMartens
Super User
1 year ago

Hey Mctwist_720 ,
creating this measure:

missing trainings = 
var allTraining = DISTINCT( ALL( 'Training Data'[Training] ) )
var completedTrainings = VALUES( 'Training Data'[Training] )
var missiingTrainings = EXCEPT( allTraining , completedTrainings )
return

IF( COUNTROWS( missiingTrainings ) = 0,
    "completed all trainings", // replace the string with BLANK() if onyy employess with missing trainings need to be listed
    CONCATENATEX( missiingTrainings , 'Training Data'[Training], "|", 'Training Data'[Training] , ASC )
)

allows me to create this table visual:

Hopefully, this provides what you are looking for.

Regards,
Tom

Mctwist_720's avatar
Mctwist_720
Regular Visitor
1 year ago

Thank you!