Regarding Power BI Function to search particular word from a column

[Sai_Kumar]

Hey Hi,

I am looking for a function to search a particular word from a given column.

Currently, I am Using 

Column_name = SWITCH(

    FALSE(),

ISERROR(SEARCH("Sai", PowerBI_Fact[Product])), "Sai",
PowerBI_Fact[Product]

The current error for this function was -  It was extracting by individual characters(Where I need to extract by exact word text).

Example - 

Products	Output
Mino sai	Sai	(Which is fine)
sai Kumar	Sai	(Which is fine)
isa	Sai	(There is no Sai in the text but it has all the words separately)

Any help can be appreciated.

Thanks.

[amitchandak]

@Sai_Kumar , try like

Column_name = SWITCH(
True(), SEARCH("Sai", PowerBI_Fact[Product],,0)>0, "Sai",
PowerBI_Fact[Product]
)