Check similarity percentage between names using DAX

Hi  Hercules78 ,

I created some data:

In DAX/Power Query, we can't check the result of each character in two columns in comparison, for example, ABC and ACB, if you don't consider this character order, you can try the following:

1. Add Column.

=Text.ToList([Group2])

Extends the value to the current table.

if Text.Contains([Group],[Name2 List]) then 1 else 0

Group BY:

Text.Length([Group])

[Match]/[Custom]

Set [Custom.1]  -- Change Type -- Percentage

2. Result:

This is the related document, you can view this content:

Fuzzy Clustering in Power BI using Power Query: Finding similar values - RADACAD

Best Regards,

Liu Yang

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