populate column based on different table

[df123445]

Hi all, 

I have 2 tables, a customer/purchase table:

customer	purchase
C1	xyz
C1	abc
C2	xyz
C3	edf

and a table that lists premium customers

customer

C1

C3

I would like to add a calculated column to the customer/purchase table that reports (yes/no) 

if the customer is a premium customer or not. Basically

customer	purchase	Premium
C1	xyz	yes
C1	abc	yes
C2	xyz	no
C3	edf	yes

Many thanks in advance 

[Ahmedx · Accepted solution]

pls try this

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.