Compare two tables in Power BI

[AdamOsmond]

Compare two tables in Power BI

I have two tables named TableOne and TableTwo. I want to display a table or matrix in my report that will give me all the towns that are in TableOne, but not in TableTwo. In the example below I want to be able to display the three red tables. Please  see the attachment. Thank you in advance. T

[v-henryk-mstf]

Hi @AdamOsmond ,

I think @PC2790  has explained the implementation steps more clearly. If there is still confusion about specific links, please point it out.

If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly.

Best Regards,
Henry

[AdamOsmond]

Please help:  I want to be able to select a person from slicer numbered 1, and then any town that is not in table 2 to be listed in table 3.  Table 2 and Table 3 have a relation in a field named "Town".  Please see the picture attached here.  Thank you in advance. 

[PC2790]

Hello @AdamOsmond ,

You can do it in PowerQuery using a simple Mquery code.

Attached is the sample report for your reference.

Thanks

[AdamOsmond]

I was able to open it, but I'm new to Powe BI.  Can you tell me the steps you did to get the new table? Thank you

[PC2790]

Sure.

Go to Power BI desktop --> TransformData

In home --> New Source--> Blank Query

In there, go to Advanced Editor and replace all the code with:

let
    addedT1_= List.Difference(TableOne[Name],TableTwo[Name])

in
    addedT1_

 Advanced Editor:

And your job is done.

Attaching the file here again

[AdamOsmond]

I can't open the file you sent me.