DAX Search for exact match within a string of text

[_Kelz0484]

Hi,

I have 2 columns within the same table and I trying to find a DAX function that uses the value of 1 column to search the other to see if it contains the 1st as an exact match.

Column 1 contains a list of fitting numbers.

Column 2 contains a description of the fitting and in some cases the fitting number as well.

• The issue I am having is that the fitting numbers are in groups ie. MW, MW1, MW2 etc etc. I have used EXACT and CONTAINSSTRING but because it finds the MW in multiple instances it tells me there is a match. I only want it to match if complete fitting number is in the description Column.

Any help would be appreciated.

[Anonymous · Accepted solution]

Hi @_Kelz0484 

Please try this m code:

let a = List.Contains(Text.Split([Description]," "),[Fitting No])
in if a = true then "Exact Match" else "Mismatch"

You can add a custom column in power query:

Then paste the code in it:

The result is as follow:

Best Regards

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

[Greg_Deckler]

@_Kelz0484 Can you provide some sample data posted as text to test with?

[_Kelz0484]

@Greg_Deckler 

 

[gmsamborn]

Hi @_Kelz0484 

Would a column llike this help?

Result = 
    IF(
        LEN( [Fitting No] ) = 0,
        "Mismatch",
        IF(
            CONTAINSSTRINGEXACT(
                [Description],
                [Fitting No]
            ),
            "Exact Match",
            "Mismatch"
        )
    )

_Kelz0484.pbix