DAX - Check if Value in one tables column exists in another

[lukeh1995]

Hi, 

I have a Staff Number ( 'Position Details'[Stafflink ID]) in one column in one table and I want to create a new column that checks if it exists in the Staff ID of another table ('Resource Plan'[Stafflink ID]). It should return YES if so, or NO otherwise. I want to use DAX rather than Power Query. What is the best way to do so?

[vicky_ · Accepted solution]

Have you tried something like:
New Column = IF('Position Details'[Stafflink ID] IN VALUES('Resource Plan'[Stafflink ID]), "Yes", "No")