Compare 2 columns in unrelated tables

[android1]

Hi,

I have 2 unrelated tables Holidays & Got Paid.

Both contain columns UniqueID, Person Name & Week Number.

How do I return the Person Name in Holidays  only if they do not appear in Got Paid for each Week Number?

[v-yuta-msft]

Hi android1,

Create a measure in Holidays using DAX like below and check if it can work.

Result =
CALCULATE (
    MAX ( Holidays[Person Name] ),
    FILTER (
        ALLEXCEPT ( 'Holidays', 'Holidays'[Week Number] ),
        NOT ( ( 'Holidays'[Person Name] IN VALUES ( 'Got Paid'[Person Name] ) ) )
    )
)

Regards,

Jimmy Tao