How to make relationship between two tables which don't have common columns ?

[dinesharivalaga]

Hi Experts,

How to make relationship between two tables which doesn't have common columns ?

Table 1 : 

Has only 6 columns

Table 2 :

Has more than 20 columns

Please suggest some ideas to make this real ..

Thanks 

DK

[WanderingBI · Accepted solution]

This is not possible in any meaningful way.

The purpose of a relationsship is to reference row values in one table to row values in another table.

Think of this example:

Sales Table

Customer Number	Product	Sales Quantity
52	Apple	3
46	Banana	2
46	Apple	3

Customer Table

Customer Number	Name
52	Dave
46	Melinda

Here you can create a n (sales table) : 1 (customer table) relationsship between the [Customer Number] columns of the two tables.

Then for each sales you could look up the name of the customer by following the relationsship.

If you do not have common columns (they do not need to have the same name - just a meaningful relationsship between the column values) then you cannot form a relationsship.

A non-meaningful way would be to give both columns an additional index column (with number 1 ... n). Then you can establish a relationsship (like match 1 and 1, 2 and 2), it just will not be helpful.

[Anonymous]

Hi @dinesharivalaga ,

Could you give an example of how you want to pass filters between two tables? That would be very useful. Thanks.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[Idrissshatila · Accepted solution]

Hello @dinesharivalaga ,

if there's no matching column in both then there's no relationship between both of them.

there's no meaning between both tables.

in general to make a relationship between two facts, you need to make a star schema data model

check it out https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

[WanderingBI · Accepted solution]

This is not possible in any meaningful way.

The purpose of a relationsship is to reference row values in one table to row values in another table.

Think of this example:

Sales Table

Customer Number	Product	Sales Quantity
52	Apple	3
46	Banana	2
46	Apple	3

Customer Table

Customer Number	Name
52	Dave
46	Melinda

Here you can create a n (sales table) : 1 (customer table) relationsship between the [Customer Number] columns of the two tables.

Then for each sales you could look up the name of the customer by following the relationsship.

If you do not have common columns (they do not need to have the same name - just a meaningful relationsship between the column values) then you cannot form a relationsship.

A non-meaningful way would be to give both columns an additional index column (with number 1 ... n). Then you can establish a relationsship (like match 1 and 1, 2 and 2), it just will not be helpful.