Forum Discussion

Helper III

4 years ago

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,...

Need Help

Anonymous
4 years ago
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

Helper III

4 years ago

Hi Tahreem24

Thank you for the reply.

Could you please check the question again as i have added a few rows because i have data similar to the updated data.

I tried the solution but it is showing an error.

Regards.

Tahreem24

Super User

4 years ago

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())

MintuBaruah
Helper III
4 years ago
Tahreem24 ,

I am still getting the error as Activity column also has duplicate data in both the tables.

Thank you

Forum Discussion

Match 2 Columns in 2 tables

Related content

Matching Column Values

Table Visual not Matching Calculated Visual

Direct Lake Model - Calculated Column/Tables

How to Count from two different table Un-matched record with New table

Matrix table column Hide