List differences between two columns of two table

Hi  Anonymous  ,

Here are the steps you can follow：

1. Enter Power query, select Merge queries as New in Home, use [Customer Table] as the main table, column Class as the associated point, and select Left Outer

2. Select all the columns of the merged table in the power query, right-click and select Remove Duplicates

3. Create calculated column.

Flag =
var _1=
SELECTCOLUMNS(FILTER(ALLSELECTED('Customer Table'),[Class]=EARLIER([Class])),"1",[Item Number])
return
IF([Item Number] in _1,1,0)

4. Place [Flag] in Filters, is=0

5. Result.

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

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