need help with combining two columns together and show differences

[bwang2]

for example in the screenshot, I want to make a New Table that I can filter column2 that only shows C and E since they do not have a corrspnding value in Table2 

[v-zhengdxu-msft · Accepted solution]

Hi @bwang2 

I've created two tables using your data:

Transform data > Home > Merge Queries

Create a table visual, the result is as follow:

Best Regards,

Zhengdong Xu

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

[TheoC]

@v-zhengdxu-msft thank you for re-writing my solution 🤔 

[TheoC]

Hi @bwang2 

You can achieve this in Power Query.

In Power Query, you can click on Merge then select "Merge as New".

Once you have the new table, you can filter out null values that don't correspond to another value in Table1[Column1].

All the best.

Theo