Search a text with all values from a column?

[powerbiuser101]

How do I search through each row in Table1, with ALL the values from Table2? 

Table1
Values	Found
A B C D	Yes
E F G H O	Yes
I J K L	No
M N O P	Yes

Table2

Values

C

F

O

 The Found column is "Yes" if any 1 value from Table2 returns True. I've tried SEARCH() and CONTAINS() but no luck.

[Zubair_Muhammad · Accepted solution]

@powerbiuser101

Try this Calculated Column

Found =
IF (
    CALCULATE (
        COUNTROWS ( Table2 ),
        FILTER ( Table2, FIND ( Table2[Values], Table1[Values],, 0 ) > 1 )
    )
        > 0,
    "Yes",
    "No"
)

[Zubair_Muhammad]

@powerbiuser101