Merging tables, data not showing

[jcastr02]

I have two tables   “Terms Count”   &   “HC Count”    where I am using merge tables to pull data from each and put into new table called  “HC and Terms”      For this example, I’ve filtered for Business Unit – Chandler, and File Date as “1/1/2020”.  

When merging I use Join Kind – left outer, but I notice that four items from “Top LOB” from the  Terms Count table (in yellow) do not populate into the new table.   Please see screen shot....                      

[amitchandak]

@jcastr02 , while join it shows how many rows match, check that number, try right or full outer join

[jcastr02]

@amitchandak I tried those, but still doesn't come up...there may be instances were there may not be a value for a specific LOB (line of business in one of the two tables) is there a way around it.....or a better way to join information from two tables?

[amitchandak]

@jcastr02 , is this not case of append columns(text and dimension) are the same .

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

also check

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

[jcastr02]

Do you know why I would get "null" in some cases, when there is a count in the terms Count? @amitchandak

[v-kelly-msft · Accepted solution]

Hi  @jcastr02 ,

If you wanna show all the rows in 2 tables,you should use "append" instead of "merge".

Merging  tables is like below:

While appending tables is like:

Using "merge",when there 's no matched values ,it will show null.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!