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 alternative funcrtion(s) you recommend using in order to achieve the same output as containsstring in Excel Power Pivot?
Thank you for your help.
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 )
1 Reply
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 )