Forum Discussion
Helper IIIMatch 2 Columns in 2 tables
Hi MintuBaruah,
I'd like to suggest you take a look at the following link about creating relationships between many columns:
Relationship in Power BI with Multiple Columns - RADACAD
You can create a calculated column concatenate these two column values and extract them to create a new clause table as the bridge to link two tables based on the merge field values.
How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive
After these steps, you can simply get the related field value based on the relationship keys.
Regards,Xiaoxin Sheng
Hi MintuBaruah,
I'd like to suggest you take a look at the following link about creating relationships between many columns:
Relationship in Power BI with Multiple Columns - RADACAD
You can create a calculated column concatenate these two column values and extract them to create a new clause table as the bridge to link two tables based on the merge field values.
How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive
After these steps, you can simply get the related field value based on the relationship keys.
Regards,
Xiaoxin Sheng