Delete a row if Asset ID is not in a table

I need an expression to delete a row from Table B.  It will delete the row if:

The [asset ID] in Table B does NOT exist in Table A.

 

Thanks

Solved Solved
0 2 81
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

NOT(IN([asset ID], Table A[asset ID]))

View solution in original post

2 REPLIES 2

Steve
Platinum 5
Platinum 5

NOT(IN([asset ID], Table A[asset ID]))

As always eactly what I need!  Thanks Steve!

Top Labels in this Space