Reply
Syndicate_Admin
Administrator
Administrator
Syndicated - Inbound

Multiply two tables

Source Community: Power BI Spanish | Source Author Name: George_2023

Base.pngTabla_1.pngTabla_2.png

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

Syndicated - Outbound

@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

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

Source Community: Power BI Spanish | Source Author Name: George_2023
Syndicated - Inbound

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
Community Support
Community Support

Syndicated - Outbound

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
Super User
Super User

Syndicated - Outbound

@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

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)