Forum Discussion
Post ProdigyMerging tables, data not showing
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!
Super Userjcastr02 , 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/
Post ProdigyDo you know why I would get "null" in some cases, when there is a count in the terms Count? @amitchandak
- v-kelly-msft
Community Support
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!