Comparing strings between two separate sheets for True/False result

[abrasington]

Hi there, new to BI and loving it so far. I would like to do the following:

Create a custom column on one sheet, which compares the string in one of the Columns (Let's say Column A) against the space-delimited string (first word) in one of the Columns (Column B) on a seperate sheet. If the string in Column B is contained anywhere in Column A, return TRUE, else FALSE. 

Any help is appreciated! 

[v-sihou-msft · Accepted solution]

@abrasington

According to your description, you have "find string" in Column A, then you want to search Column A, if the delimited string is included in any Column A entry, then return TRUE, otherwise FALSE. Right?

In this scenario, you can put SEARCH() function into SUMX() to get the total index for each delimited string. Please see my sample below:

Column = IF(SUMX(String,SEARCH(Word[Word],String[String],,0))>0,1,0)

Regards,