Test IF string exists based on a list of values

[scottworkmanUG]

I have a column of comments in Table1. I have a column of keywords in Table2. 

I want to flag TRUE or FALSE if the comments from Table1 contain any of the keywords from Table2 for each record. The complete keyword needs to be present in the comment.

Thanks.

Scott

[v-chuncz-msft · Accepted solution]

@scottworkmanUG,

You may refer to the DAX below.

Column =
COUNTROWS (
    FILTER (
        Table2,
        SEARCH ( " " & Table2[keywords] & " ", " " & Table1[comments] & " ", 1, 0 )
            > 0
    )
)
    > 0