Match partially exact records from 2 tables

[saipawar]

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	Quarter	Pipeline Value
Adobe	FY21 Q1	$23
Adobe EMEAR	FY21 Q2	$1
Adobe NYC	FY21 Q3	$56
Netflix India	FY21 Q2	$20
Qualcomm APJC	FY21 Q3	$30
Google	FY22 Q1	$50

[Greg_Deckler]

@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