Forum Discussion
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.
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.
Hello Anonymous , you did it! I will mark yours as the solution however there is one minor correction. The Master Table is the main table and the customer table is secondary.