List in a list from two separate tables

what is the correct expression to do this?
the result should be a single value from Table 1 column [Check Number] that is not existing in Table 2 Column Check Number].
Basically Comparing two lists and extracting a single value that is not in the other.

Thanks

Solved Solved
0 13 311
1 ACCEPTED SOLUTION

Gents,
I have come up with this:

(Order Details[Check Number] - LIST())

(Month Finance[Check Number]- LIST())

always grateful

View solution in original post

13 REPLIES 13
Top Labels in this Space