Forum Discussion
Solved
Match 2 Columns in 2 tables
Hi @all I have 2 tables, Table A and Table B. The condition is to match 2 columns (ie, Activity Group and Activity) from Table A with 2 columns (ie, Activity Group and Activity Desc) of Table B,...
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
MintuBaruah Then try this:
Join based on Activity column.
Column = IF(TableA[Activity Group]=RELATED(TableB[Activity Group]) && TableA[Activity]=RELATED(TableB[Activity ]),RELATED(TableB[Rates]),BLANK())
I am still getting the error as Activity column also has duplicate data in both the tables.
Thank you