Fuzzy Match calculation explained

Hi jhamil560 ,

About similarity threshold in fuzzy match, here is the explaination in Power Query editor in Power BI Desktop:

Similarity Threshold:

Indicates how similar two values need to be in order to match. The minimum value of 0.00 causes all values to match each other. The maximum value of 1.00 only allows exact matches. The default value is 0.80.

To check the calculation of this threshold, you can create a table in Power Query online(dataflow) to use cluster values feature, please refer this document which introduces it in details:

How fuzzy matching works in Power Query? 

Note:

Currently only the Cluster values feature in Power Query Online will provide a new column with the similarity score.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.