Compare two tables to get match and unmatching values

[markworks]

Hello! I am relatively new to Power BI. I might be overcomplicating things with this tool. 

My data comes from excel, and I want to know if it's possible to compare my source data (an extract from a work tool), versus what we should have (second table). Basically, I want to know if a certain resource has done or not a course, and it occurs to me doing that by comparing. 

Source data is as follows: 

Name	Board	Course
Mark Moore	Leadership 101	The challenges of being a leader
Aaron Bulaga	The Digital Era	Becoming Digital

The data that we should have is the following: 

Board	Course
Leadership 101	The challenges of being a leader
Leadership 101	Leading with example
The Digital Era	Becoming Digital
The Digital Era	Digital Age

Is there a simple way to compare two tables and bring the differences in power bi? 

Note: my source data is actually around 15000 lines, this is just a quick sample. 

Thanks in advance for your help!

[danextian · Accepted solution]

Hi @markworks ,

I am not sure whether you want to bring in non-matching rows or or only row with a match. Either way, this can be done in Power query but may take several steps dpending on the the desired result. I've attached a sample PBIX. Go to Home then Transform Data to inspect the steps.

https://drive.google.com/file/d/1-bD13Hz82V1ulv-AJhlcSRYGhBorwM0I/view?usp=sharing