Multiply two tables

[Syndicate_Admin]

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]

Thank 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

[v-jingzhang]

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

[amitchandak · Accepted solution]

@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