Add new column to a table based on column in another table

[Upali63]

Hi Friends

 I have following two tables in my project . 

Now I want to check if CODE in Table 1 exists in Table 2 and If true a new column should be added to table 1 marked as 'Y' and if false new column should be marked as 'N'. Required output table is shown below. Kindly help to solve the issue.

[YukiK]

Assumming you have a relationship between the two on CODE. You should be able to do something like this:

FLAG calculated column = 
IF (
    Table1[CODE] = RELATED( TABLE2[CODE] ),
    "Y",
    "N",
)
 

[Upali63]

Thnaks,

It is not working my friend