Forum Discussion

DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
2 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • ThxAlot's avatar
    ThxAlot
    2 years ago

    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 )
ThxAlot's avatar
ThxAlot
Icon for Super User rankSuper User
2 years ago

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 )