Forum Discussion
netanel
Post Prodigy
Post ProdigyHow do you multiply a column from one table by a column from another table?
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?
amitchandak
Super User
Super Usernetanel , 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
netanelHey amitchandak First of all love your channel, always find in it something new to learn.
Second, I received this message: