Fuzzy match / merging in Power BI Desktop (October 2018)

In this video, we look at the new fuzzy match / merging option within the October 2018 version of Power BI Desktop. This feature is incredibly powerful when it comes to data matching and can be adjusted to meet your needs.

LET'S CONNECT!

Guy in a Cube
-- Snapchat - guyinacube

***Gear***

#powerbi #powerbidesktop #guyinacube

[jimfollen]

You guys rock, love your PBI videos. They have become my go-to when I need to learn new techniques or functionality. Thanks!

[marjoriejorgensen]

Love your videos. Your energy/personality and training style is easy to follow and VERY MUCH appreciated! Keep it up.

[krupeshdesai]

Great Videos Guys. Thank you for helping me to get my Power BI certification done. I am writting this from New Zealand and the Desktop Image in the background is just 2 hour drive from my home. It's called "Wharariki beach"

[asjones]

So the transformation table has to have headers of to and from? what if there was a join going the other way also? To be safe do we need to have "William" and "Bill" on both sides in the table? Thus "William" & "Bill" AND "Bill" & "William" ?

[RH-nkeo]

Can the transformation table contain multiple entries? e.g. Jim -> James, Jim -> Jamie etc.

[patrickstokes]

Can you merge fields across multiple data sources to create a master Dimension table?

[livio]

This is a super great addition, especially when working with data coming from those pesky .csv, .txt and excel files filled in by people who got no clue whatsoever :D)
OUTSTANDING

[kirstyclark]

It'd be great to know more about the % accuracy and how that works rather than doing a bucketload of trial and error.

Thanks for the video, great as always.

[FelixFrost]

nice! loved this guy's energy. Keep it up team!

[dhawalpmehta]

This is super cool, i had to do separate Error reporting for the typo earlier to fix this kind of issues where i was using anti joins to report the errors. But now i don't need to worry. Thanks Pat Fuzzy Matching with Patrick for this demo :)

[Fiktage]

Great features! Thanks Patrick for good & simple review as always! i was stuck with the same problem during comparing of two tables (nested join)... i used to make lower case first, than trim, clean... after join.

[panayiotisagapiou]

What if the name is a 3word name (e.g. Chris Down Michael & Michael Chris Down) in the 1st table and in the 2nd table the name i have only 1word names (e.g. Chris). How i am gonna merge this? There is match in both rows of table 1. Thanks!

[selfservicebi]

Great addition to Power BI Desktop. Looking forward to having it GA together with Composite Models and PDF parsing.

[gilmijar]

I wonder what algorithm is used to calculate similarity (or diffeence) between strings in Fuzzy Merge. Is it the good old Levenshtein, Longest Common Substring, or something else?

[arjunkoli]

Can fuzzy map work with making relationship between data, other than merging

[igershe]

Can you do fuzzy joins in Excel when joining tables in the data model? I want to join multiple tables for my Powerpivot but I need to use fuzzy matching because I can't match the data exactly. thanks

[paultoyle]

can you make a video to compare a string with a numeric value using if statement or switch statement please

[daphnerosario]

Great video! I'm learning so much; love your genuine enthusiasm. Is there a way to reach out to ask a question?

[sofyan]

Hi,
Thanks for great help. You video is actually helping me learn power bi. Have one limitation in power bi i couldn't get workaround for.
How could i filter data in other sheets of my report based on a scatter plot in my landing page. There is report level slicer i read about but i need scatter plot to filter the data

[busello]

Great tools! I have trouble with slow refresh and query application. I have about 3000 records to match with other table of 7000 records, and it takes hours! Any suggestions from where to start?