Forum Discussion
Multiply two tables
- 3 years ago
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
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