Merge or Append Queries?

[Anonymous]

I have multiple queries that have all the same columns except for the values column. I am wanting to combine the value columns from the different queries into one query and of course have my DIM table referencing that. (This is what I am assuming is correct)

I have tried merging (and tried many different modifications of merging) but end up having duplicate rows. 

When I try to Append, I end up getting null values in the value column and when I filter the column to eliminate the null, the other value column then shows null.

I am very confused as I do not believe that this should be a difficult task but am having a lot of trouble getting past this.

I have attached my power bi file below, hopefully I have attached it right as this is my first time sharing it. Thanks!

Power BI File 

[amitchandak]

@Anonymous , do you have correct keys identified join. Do you need a concatenated columns for that ?

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

[Greg_Deckler]

@Anonymous - Can't access file. Generally this sounds like an Append. Are you sure that your column names, including the value column are all identically named? If you Append with all the same column names, you should not end up with 2 values columns.

[Anonymous]

I made the column names identical and you are correct, I did not end up with an additional value column. However, I am thinking that I am going to need to merge instead if I am aiming to add additional columns that contain the values of my other queries. When I merge and match the Dept-ID using Left Outer Join and expand only the Value column, my Dept-ID and Department rows duplicate. Here is a snip just so you have an idea of what I am looking at.

@Greg_Deckler 

[Greg_Deckler · Accepted solution]

@Anonymous - You can merge on multiple columns using Ctrl or Shift to select

[Anonymous]

This is correct how it is in the snip, but once i merge, those two columns (Dept-ID and Department) go on for hundreds of rows. Also, my weeks columns has 'Week 1' for 52 rows for the same Dept-ID and Department.

@Greg_Deckler