cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
saipawar
Helper IV
Helper IV

Match partially exact records from 2 tables

Hi, 

I have two tables, one with parent company names and other with pipeline values that contains parent company and branches. I want to join them in such a way that company name is the primary key and it should pull the branches name from table 2 . Note, how Google is present in Table 2 and should not be included in the join

 

Table 1

Comapny Name
Qualcomm 
Adobe
Netflix

 

Table 2  

Company Name QuarterPipeline Value 
AdobeFY21 Q1$23 
Adobe EMEARFY21 Q2$1 
Adobe NYCFY21 Q3$56 
Netflix IndiaFY21 Q2$20 
Qualcomm APJC FY21 Q3$30 
GoogleFY22 Q1$50 
1 REPLY 1
Greg_Deckler
Super User
Super User

@saipawar You can use a Merge query in Power Query Editor and use the Fuzzy matching criteria. Or, I built a DAX version as well: Fuzzy - Microsoft Power BI Community


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!