Forum Discussion

karimk's avatar
karimk
Helper III
4 years ago
Solved

Merging 2 tables with complementing data

Hi. I have an Excel file with 2 sheets: 1) List of people and the courses they have taken, as well as the department they belong to in our company; 2) List of departments and the courses available ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my solution file from here.

    Hope this helps.

jaipal's avatar
jaipal
Resolver III
4 years ago

Hi karimk , go into power query and merge two tables this this

 

you will get a new table. 

 

Now, go into the Power BI and do your visuals

 

  • karimk's avatar
    karimk
    Helper III
    4 years ago

    Hi. Not sure if it worked. I added a sheet to show the expected result. Below is a screenshot. I want to be able to see the courses taken, the ones that were not taken and if those are even offered, per person.