Containsstring dax equivalent in Excel Power Pivot

[DataNinja777]

Hi Power BI community,

I'd like to use Containsstring dax function in Excel, but it appears that this dax function is not present in Excel Power Pivot.  Please could you let me know which alternative funcrtion(s) you recommend using in order to achieve the same output as containsstring in Excel Power Pivot? 

Thank you for your help.

[ThxAlot · Accepted solution]

CONTAINSSTRING is syntax sugar for SEARCH; thus the alternative is like,

FILTER( tbl, CONTAINSTRING( tbl[Text], "XYZ" ) )
<==>
FILTER( tbl, SEARCH( "XYZ", tbl[Text], 1, 0 ) > 0 )