Comparison of 2 columns with approximately the same values

[GillesDesbois]

hello
I have 2 tables

table 1 column 1 with all values
table 2 column 1 with same value as table 1 column 1 but not all the value

I want to have a new column in the table 1 which tell me if the value in column 1 is also present in table 2 and this, value per value

ex :

table 1 column 1	table 1 column 2		table 2 column 1
a	present		a
b	not present		f
c	not present
d	not present
e	not present
f	present

Hope I'm clear
if someone has already found this issue and solved it, please help me

Gilles

[AlB · Accepted solution]

Hi @GillesDesbois 

Try this for the new calculated column in 'table 1':

column 2 =
IF (
    COUNTROWS ( FILTER ( 'table 2', 'table 2'[column 1] = 'table 1'[column 1] ) ) > 0,
    "present",
    "not present"
)

[GillesDesbois]

hello

sorry for my late answer

yes it works

a great thank for your help

Gilles