Creating a new column based on values from two different columns

[anwarbi]

I have two tables-  Table 1 and Table 2 (refer below tables) . Table 1 has all the customer names and table 2 has a list of selected customers. 

I want to create a column in Table 1 with a flag "Y" if the values from Table 2 matches values in Table 1 and if they dont match then the result should be "N"

Table 1 

Customers

A

B

C

D

E

F

G

H

Table 2 

Selected customers

A

B

C

Result should be as below - Table 1 with a new column

Customers	New Column
A	Y
B	Y
C	Y
D	N
E	N
F	N
G	N
H	N

Thanks.

[v-zhangti · Accepted solution]

Hi, @anwarbi 

You can try the following methods.

Column = 
IF (
    LOOKUPVALUE (
        Table2[Selected customers],
        Table2[Selected customers], [Customers]
    )
        <> BLANK (),
    "Y",
    "N"
)

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@anwarbi , New column in table A

Column =

var _cnt = Countx(filter(Table2, Table2[Selected Customer] = Table1[Customer]), Table2[Selected Customer])

return

if(not(isblank(_cnt)) , "Y", "N")