Forum Discussion
Merging tables, data not showing
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....
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,
KellyDid I answer your question? Mark my post as a solution!
5 Replies
jcastr02 , while join it shows how many rows match, check that number, try right or full outer join
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?
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/
