Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

Comparing Reference Column to Actual Column (text)

I am trying to track training status of employees, and identify which training each employee should take next, based on required/recommended courses and historical information. Following are some relevent tables. These tables can be changed to facilitate the analysis. Any help would be appreciated.


Required/Recommended Training by Role

DeveloperCourse ACourse BCourse FCourse GCourse H  
BACourse BCourse CCourse ECourse ICourse JCourse KCourse L
TesterCourse ACourse BCourse FCourse GCourse H  
ManagerCourse B Course CCourse DCourse M   


Historical Training

Course IDCourseStart DateEnd DateName
1Course 14/1/20224/15/2022John
2Course 14/1/20224/15/2022Jane
3Course 24/16/20224/30/2022Sarah
4Course 24/16/20224/30/2022Tom


Employee Role



Super User
Super User

Unpivot "Required/Recommended Training by Role" to create a table with

Role and Course because tabulare tables are much easier to work with. 😀


Data clean the Course ID so the "Historical Training" and "Required/Recommended Training by Role" correspond because you cant not relate Course 1, 2,3 to Course A. B, C



Build a 1:M relationship from Employee Role[Name] to "Historical Training".


Build a 1:M relationship from Employee Role[Role] to "Required/Recommended Training by Role".


I think you will be able to do the rest, but ask if you need more help. 


I helped you so now please help me.

Click the thumbs up and Accept ad Solution to leav ekudos.
Thankyou 😀

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.