Forum Discussion
Solved
Fuzzy Merge - similarity score
Dears I'd like to have as an output of a fuzzy merge also the similarity score to apply some fine tuning to the algorithm. I saw on power query documentation there was an option to expand that value ...
Yes, that documentation should have noted that this is a feature available only for Power Query Online (app.powerbi.com). This feature is still not transported to Power BI Desktop / Power Query Excel. You need to be having at least Power BI Pro subscription to use Dataflows which will enable you to use PQ Online.
See the snip from Power Query Online.
How to join 2 columns in fuzzy merge
Below is the table with columns.
- Department_Id
- Employee_Id
- Employee_Name
Within same Department_Id, how to do Fuzzy Merge/match on Employee_Name with score 65% and number of matches = 10