Forum Discussion
Fuzzy Matching in Power Query Not Working
What if I want it to produce a new column that provides the match so I can see them side by side to see the differences? Essentially I'm trying to isolate which ones are new customers and which ones aren't using the fuzzy match. I'm not 100% sure if this is the best way to do it in Power BI and there may be a better way but this is what I came up with in my research.
Go to the full list.
Use the Merge options as before.
This time choose the Left Join that will return all rows from the ALL customers table and Matching from the Old customer table.
A column called Old Customer will be created click on the expand arrows to the right of the column.
From the expand option you can choose which columns to pull through from the other table.
Alternitively if you don't need any data from the other table you could choose Aggregate.
Then set it to count the customer ID or name.