Search for text within a string - make dynamic

[Andybr]

Hi,

I want to search for a particular word in a column within the table.

I want to be able to pass in the search word as a variable value, so can make this dynamic, can it be done?

My code currently looks like this:

SearchForString = IF(

    ISERROR(

        SEARCH("Word", 'Table'[Column)

    ),

    "No Match","Match"

)

[amitchandak · Accepted solution]

@Andybr , refer if this can help

https://exceleratorbi.com.au/text-filtering-power-bi/

https://www.youtube.com/watch?v=FMjlmV8-UU4

[az38]

Hi @Andybr 

try

SearchForString = IF(
   SEARCH("Word", 'Table'[Column), , 0) > 0,
   ,"Match",
   "No Match"
)