Forum Discussion
Helper VIf column contains values from column in another table...
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!
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.
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])
8 Replies
KGriceMemorable Member
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.
- bullius
Thanks for the reply.
Table2 does not contain unique values...
