How do you multiply a column from one table by a column from another table?

[netanel]

Hello everyone!
I have two tables Table 1 and Table 2
How do I multiply a column value from table 1 by a column value 2 from table 2?

[Anonymous]

Hi @netanel 

You can create a column to return the values of Table1[Value]* Table2[Value]

Column = CALCULATE(MAX(Table1[Value])*MAX(Table2[Value]),FILTER(Table1,Table1[Name]=Table2[Name]))

The effect is as shown:

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[netanel]

Hi @Anonymous  Thanks for the response,
The formula does not work for me because I have many-to-many interactions between the two tables

[amitchandak]

@netanel , Try

new column in Table 1 =
maxx(filter(Table2, Table2[Name] = table1[Name]), Table2[Value2]) *Table1[Value]

or

new column in Table 2 =
maxx(filter(Table1, Table2[Name] = table1[Name]), Table1[Value]) *Table2[Value2]

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[netanel]

Hey @amitchandak First of all love your channel, always find in it something new to learn.
Second, I received this message: