Issue merging columns

[Lilushkam]

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!

[Anonymous · Accepted solution]

Hi @Lilushkam 

When you merge them, you will see a table column in the current table.

e.g 

Then you just need to expand the table, click the icon

e.g 

Then select the column you want to display.

Then you can display the columns to the current table.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mlsx4]

Hi @Lilushkam 

In the step where you get "Table" in all rows, then you can expand the column you need. Don't you get an icon with a kind of arrows?