If column contains values from column in another table...

[bullius]

Hello

I would like a column that shows whether or not a column in Table2 contains values that are in Table1.

Table1
Value	New Column
A	TRUE
B	FALSE
C	TRUE
D	FALSE
E	TRUE

Table2

Value

A

C

E

Any Ideas?

Thanks!

[KGrice · Accepted solution]

Hi @bullius. If table 2 contains only unique values, you could relate the two tables on the Value column, and then use this formula for your New Column:

New Column = NOT(ISBLANK(RELATED(Table2[Value])))

You can also use the formula below, which will work with or without the relationship:

New Column = CALCULATE(COUNTROWS(Table2), FILTER(Table2, Table2[Value]=Table1[Value])) > 0

See this post for more information about how each method works.

[KGrice · Accepted solution]

Hi @bullius. If table 2 contains only unique values, you could relate the two tables on the Value column, and then use this formula for your New Column:

New Column = NOT(ISBLANK(RELATED(Table2[Value])))

You can also use the formula below, which will work with or without the relationship:

New Column = CALCULATE(COUNTROWS(Table2), FILTER(Table2, Table2[Value]=Table1[Value])) > 0

See this post for more information about how each method works.

[Anonymous]

Although I have a relationship the second option is not working.

[bullius]

Thanks for the reply.

Table2 does not contain unique values...

[KGrice]

Hi @bullius. The unique values piece only matters for creating a relationship. The second option I listed does not require unique values in either table. Were you able to get that one working?

[bullius]

Yes! The second one does the job. Thanks!

[jahida · Accepted solution]

I know KGrice's formula worked but it does seem a tad clunky... you could consider this as a slightly cleaner alternative (since the CONTAINS function exists exactly for this purpose):

Column = CONTAINS(Table2, Table2[Value], Table1[Value])

[Anonymous]

 but with this method, there has to be a relationship established between tables, right ?

[KGrice]

Thanks, @jahida. I hadn't come across the CONTAINS function yet. I'll start using that instead.