Issue merging columns

Hi everyone! 

I had 2 PowerBI training sessions and I'm trying to practice by creating reports, yet I feel completely dumb because I have trouble doing it... 

The report I'm trying to create : I have two student lists (sales and academic) and want to cross check the student state for X semester to find variance.

Tables :

Sales list information = Semester (September, October...) / Student code (unique) / Name, surname / Program / Campus / Sales status

Academic list information = Semester (September, October...) / Student code (unique) / Name, surname / Program / Campus / Academic status

My goal = What I want to do is to check is if let's say student John has a sales status NEW in October in Harvard and an academic status NEW in October in Harvard as well. I want to create a variance report if that's not the case, if John is NEW according to Sales but Cancelled according to Academic for same semester same campus. 

What I've tried to do =

1. Import these two lists from a Sharepoint (my fact tables),

2. Add mapping table such as Program type, Campus, Semester (my dimension tables),

3. Clean it and create a KEY : concatenate Semester + Campus + Student code 

What I'm struggling to do = 

 I want to merge it with the key to have in one list both the academic status and the sales status but it doesn't work. When I merge it, I only have one new column named "Shared list" with only "Table" in all rows. 

Moreover, I was taught to have a "star" scheme with one fact table and multiple dimension, but I have two fact tables with these two lists... 

I can do it in excel by doing quick vlookup or in knime by creating a group by or a join and I would love to have the powerbi logic but I don't.... could you please help me ? 😬

Thank you!