Forum Discussion
Solved
Containsstring dax equivalent in Excel Power Pivot
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 alter...
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 )
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 )