Merging tables but only displaying the mismatches

[russelld]

Hello,

I'm a very new PowerBI user and just working my way through some of the courses offered Udemy, which may I add have been great so far 🙂

Anyway, I have an issue which I'm pretty sure is easy to do but I cannot find the information anywhere. I have two queries which are identical in row size and formats which I'm trying to merge into one query but only show exceptions.

For example in column A I have the numbers 1, 2, 3 and in column B I have the number 1, 2 therefore on the merged report I only want the number 3 to appear as the unique identifier. Is this possible?

I know I can do this easily in excel although I would like to get my BI skills up to scratch!

Thanks in advance and I look forward to using this forum.

Russell

[v-alq-msft · Accepted solution]

Hi, @russelld 

Based on your description, I created data to reproduce the scenario.

 

You may click 'Edit Query', go to Query Editor, choose 'Home' pane, select 'Merge Queries'.

Then you can configure as follows.

Finally you may expand Table(2) as follows.

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[russelld]

Thank you for the replies, 99% worked the reason for it not working perfectly was an issue on my data.

Thanks again.

[VasTg]

@russelld 

Russell,

One way to do it is by using Merge queries.

Choose all the columns in two tables and use "Left Anti(rows only in first)" as Join kind.

As a next step, select "Choose Columns" and choose the desired columns( or uncheck Table column).

If this helps,mark it as a solution

Kudos are nice too.

[parry2k]

@russelld are you referring to columns A and B, or these tables, Table A and Table B?? How you want output to be? Always check A and see what doesn't exists in B?