Forum Discussion

P_Allert's avatar
P_Allert
Frequent Visitor
2 years ago
Solved

Comparing list values to find similarities

I have a list of values, each 2-4 characters long. This is an example of such a list: 7R 31A 1AB 3ZB 1EM 8Z 9UZ 7FH 42AB   I would like to find out if any of the values in the list is simi...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    P_Allert Could you just use Fuzzy matching in a join/merge query? Table.FuzzyJoin and Table.FuzzyNestedJoin. If that does not provide enough flexibility, I created a DAX version that you can tweak and tune as you see fit.

    Fuzzy - Microsoft Fabric Community

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

P_Allert Could you just use Fuzzy matching in a join/merge query? Table.FuzzyJoin and Table.FuzzyNestedJoin. If that does not provide enough flexibility, I created a DAX version that you can tweak and tune as you see fit.

Fuzzy - Microsoft Fabric Community

P_Allert's avatar
P_Allert
Frequent Visitor
2 years ago

Hi Greg,

thanks for your reply.

 

The FuzzyNestedJoin-Hint did it. I had already played around with it a few hours ago, but didn't succeed then.

 

The Fuzzy Solution in DAX looks very impressive and I'll definately try to figure out how it works, even though may limited DAX skills will make this an "interesting" journey... ðŸ˜ƒ

 

Thanks again.

 

Cheers
Patrick