Training Eligibility Calculated Column

Hi shantupm5 ,

Thank you for reaching out to the Microsoft fabric community forum.

 

Since the eligibility logic especially for Digital Training, where an employee must complete all trainings from at least one valid combination is too complex for a calculated column, Power Query is the most effective approach.

 

Here's how you can implement it step-by-step: First, split the training combinations in the Eligibility Matrix into individual rows, and assign each combination a unique ID. Then, merge this with the Employee Database using Job Level and Industry to match each employee to their applicable combinations.

Next, join this with the Training Completion Report to identify which required trainings each employee has completed. By grouping and comparing the number of trainings completed against the total required per combination, you can identify valid completions.

Finally, aggregate at the employee level to flag whether they’ve completed any full combination, and merge this result back to the Employee Database table to mark each employee as "Eligible" or "Not Eligible".

 

Let me know if you'd like to apply the same logic for Domain Training as well, or if you'd like a sample PBIX for reference.

 

Thank you.