Forum Discussion
Optimizing Fuzzy Merge
Hi akg ,
I have tested the sample data. It works using transformation table. You could download my sample to have a try.
Reference:
Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold
If your tables still can't work fine, maybe it is caused by the sample data is too simple. Please share a dummy pbix file that we can test.
Here is a sample of my .pbix in Onedrive:
https://1drv.ms/u/s!As6Gm7qZSazFmSdN0X_5Z7qeNoBp?e=EnJrXJ
I've taken few different account names I was having trouble with along with some other random names to try and represent the dataset and created the bridge along with fuzzy merging. I have removed the duplicates so that the relationships will work, but if you roll it back you can see where the names arent lining up properly.
In this sample every account name has a match in the Fuzzy Match transformation table I loaded, but this is not always the case. My original transformation table only really includes matches for the obvious account names that I want matched. For example, I have ATT West in the "from" column of the fuzzy match transformation table, but this wouldn't normally be included in that table at all.