Forum Discussion
Multiply two tables
Dear your help, I have a table made and I need to generate the multiplication of 2 columns that come from different files. uni has the value and the other the quantities in units, both are related by the SKU of the product. Stay tuned
Syndicate_Admin , You can do that across common dimension
example
sumx(Product, calculate(sum(Table1[Value]) * Sum(Table2[Price]) ) )
or bring in data from one table to another
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
3 Replies
Syndicate_Admin , You can do that across common dimension
example
sumx(Product, calculate(sum(Table1[Value]) * Sum(Table2[Price]) ) )
or bring in data from one table to another
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8Thank you very much, I have solved according to the references of the Youtube videos, although it was not so accurate it helped me to solve
Hi George_2023
Can you share some sample data of two tables and the expected output in table format? This can help us understand the requirement better and try to provide a more detailed solution.
Best Regards,
Community Support Team _ Jing
