Forum Discussion

meenakshiramdeo's avatar
meenakshiramdeo
Frequent Visitor
2 years ago
Solved

Find exact substring in string/description

I want to search for exact string in a column and then get a true or false result. For eg If I have to search "AGRESSIVE" or "CLIENT Not" in   "Welcome: This is agressiveness behaviour"   I am cu...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi meenakshiramdeo 

     

    The following method is for your reference:

     

    Sample:

     

    Create a measure as follows

    Measure = IF(CONTAINSSTRINGEXACT("aggressive", MAX([Column])), "True", "False")

     

    or a calculated column as follows

    Column 1 = IF(CONTAINSSTRINGEXACT("aggressive", [Column]), "True", "False")

     

    Output:

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

Hi meenakshiramdeo - Can you try below dax function Contrainstring to get the exact string match

ExactMatch =
IF (
OR (
CONTAINSSTRING(" " & YourTable[YourColumn] & " ", " AGRESSIVE "),
CONTAINSSTRING(" " & YourTable[YourColumn] & " ", " CLIENT Not ")
),
TRUE(),
FALSE()
)

 

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!