Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
mukeshmutreja
Microsoft Employee
Microsoft Employee

Multiple relations

How to create multiple column relations between two tables.

 

For Ex:

 

I have two tables:

 

1. Product Group table

 

CompanyProduct GroupProduct
APG1ITM1
APG1ITM2
BPG2ITM1

2. Sales Table

 

CompanyProductSales Amount
AITM1100
AITM2200
BITM1

300

 

Requirement is to fetch the Product group from table 1 based upon company and product values from table 2.

 

1 ACCEPTED SOLUTION
itayrom
Resolver II
Resolver II

In Power BI's model, a relationship can be created between two tables only by connecting a single column from each one.

Therefore, what you should do is add a key column to each of the tables that concatenates the Company and Product columns values for each row. You can do this either via a DAX expression or in Power Query.

 

For example, you can create a calculated column in each table using the following DAX expressions-

In the Product Group table-

Key = 'Product Group'[Company] & "|" & 'Product Group'[Product]

 

In the Sales table-

ProductGroupFK = 'Sales'[Company] & "|" & 'Sales'[Product]

 

 

And then create a relationship between them.

View solution in original post

1 REPLY 1
itayrom
Resolver II
Resolver II

In Power BI's model, a relationship can be created between two tables only by connecting a single column from each one.

Therefore, what you should do is add a key column to each of the tables that concatenates the Company and Product columns values for each row. You can do this either via a DAX expression or in Power Query.

 

For example, you can create a calculated column in each table using the following DAX expressions-

In the Product Group table-

Key = 'Product Group'[Company] & "|" & 'Product Group'[Product]

 

In the Sales table-

ProductGroupFK = 'Sales'[Company] & "|" & 'Sales'[Product]

 

 

And then create a relationship between them.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!