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 currently using CONTAINS function and it gives me true as agressiveness has AGRESSIVE but I need false so if exact search exist then  only result should be true and false in below case like -

"Aagressive"

"agressiveness"

 

 

Thanks

Meenakshi Ramdeo

 

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.

3 Replies

  • 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!!

  • meenakshiramdeo's avatar
    meenakshiramdeo
    Frequent Visitor
    2 years ago

    This will not help as adding space in YourTable[YourColumn] will become " Welcome: This is agressiveness behaviour "

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.