Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 | |
FY22 Q1 | $50 |
@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