Calculation between two tables having many to many relationship

[shoaib986]

Hi 

I have two tables Table_1 and Table_2 with many to many relationship.

I just want to do simple calculation of Table_1.Column_1 * Table_2.Column_1 where the two tables are connected by Column_3 with many to many relationship in both directions.

Please advise.

Thanks in advance.

BR

[v-juanli-msft]

Hi @shoaib986

To create many to many relationship, you could enable "composite models" feature.

You can enable this by navigating to file > options & settings > options > preview features > and checking off composite models.

Reference:

HOW TO JOIN MANY TO MANY WITH A BRIDGE TABLE IN POWER BI

Below is my test for example.

 

note: since for the same value(eg."a")in column3 in table1 and table2, there are many different values in column1 of table1(1,2,3 for "a") and in column2 of table2 (10,11,12 for "b"), when you calculate them, you need to use aggreation function like "sum, max, min" ect.