Find exact substring in string/description

[meenakshiramdeo]

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

[Anonymous · Accepted solution]

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.

[meenakshiramdeo]

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

[rajendraongole1]

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