Merging tables - Matching rows + left and right unmatched

[mchacha]

Hi,

I'm kind of novice in PowerBI 

I have a table with ID / Name / Delivery note Number / Invoice number (if any) and other information (amount, paid, pending). 

I have another table with ID / Name / Delivery note Number (if any) / Invoice number and other information. 

Normally, each invoice should have a delivery note associated BUT for a reason we enable invoice to be created without delivery note. 

What I did is to join tables and to match rows (perfect situation is same line for DN + invoice) and left unmatch (only DN info) or right unmatch (only Invoice info) => the thing is, I will then have ID (DN) and ID (Inv) but as well Name (and other info that I didn't put there because it would be too long) in different columns instead of one. So I thought I could do extra columns for each of these situation like ID (general) = if ID (DN) is blank then retrieve ID (invoice) else retrieve ID (DN) and then remove the ID (invoice) and ID (dn) but I would need to do that for like 6 other columns and I feel I'm missing something but my head is burning

My question would be, is that the best way to do it ? Do you please have any advice on how I could proceed ? 

I could use 2 separately but I need to merge that table afterwards with another one which has more "qualitative" information" about the ID user, that is why... 

Thank you!! 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...