Forum Discussion

Andy83's avatar
Andy83
Frequent Visitor
2 years ago
Solved

DAX: Searching for strings in a text column.

Hello all,    I am just curious if there is a way to solve this. I have a text column and I am searching this column using an excel table which is working fine but say one of my keywords is "leg" i...
Need Help
  • DataInsights's avatar
    DataInsights
    2 years ago

    Andy83,

     

    Here's an example of how you could write it:

     

    Test Measure = 
CALCULATE (
    COUNTROWS ( Table1 ),
    CONTAINSSTRING ( Table1[Column1], " leg" )
        || CONTAINSSTRING ( Table1[Column1], "leg " )
)
DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
2 years ago

Andy83,

 

Here's an example of how you could write it:

 

Test Measure = 
CALCULATE (
    COUNTROWS ( Table1 ),
    CONTAINSSTRING ( Table1[Column1], " leg" )
        || CONTAINSSTRING ( Table1[Column1], "leg " )
)