Imagine this. We have been given a list of products from company A and a list of products from company B.
Our job is to match products between the two lists. But each company might have slightl...
Updated Apr 24, 2020
Version 7.0
Blog Post
"What a time saver! I only wish I had this years ago."
You did have this in Excel since late 2010 as an Add-in called Fuzzy Lookup
https://www.microsoft.com/en-in/download/details.aspx?id=15011
Since then it has had exactly 1 Update in (2014)
This huge time save was neither promoted by Microsoft nor were efforts made to fully integrate it to Excel.
In PBI it came only 3 years (Oct 2018) after the "Idea" submitted on June 2015. In Excel it came even later.
Even in its current implementation there are some gaps. For E.g. in the Excel Addin we can have a column that gives a % indicating Jaccard's index of similarity - In PQ this column is missing. Before you suggest I have already submitted it as an Idea - But I am sure a few years from now it will get implemented
Also there is no way currently of clustering in to Fuzzy Groups or deleting Fuzzy Duplicates.
Conclusions:
MS will remain a company with unlimited potential and limited vision
Sam