Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

multiply tow columns from different tables

Hi,

 

I am very new to BI and im sure this should be simple but cant get it:

 

I need to multiply a Weight field in one table by a value column in another table ie:

 

Table 1

Col1 Type name

Col2 Type Weight (in KGS)

 

Table 2

Col 1Type name

Col2 Type Value (per KG)

 

I want to create another column in Table 1 which gives me the total value i.e weight*value per KG = Total Value

 

Thanks in advance!

 

1 ACCEPTED SOLUTION

Give this a try.

Amount = SUMX ( 'Scrap Data (2)', 'Scrap Data (2)'[Weight] * RELATED ( 'Scrap Type Values (2)'[Value]) )

View solution in original post

7 REPLIES 7
jdbuchanan71
Super User
Super User

@Anonymous 

How are the two table joined together?  Can you show a picture of the model view (tables and join arrows)?

Anonymous
Not applicable

They are joined by Scrap Type Name:

 

Disco_0-1594440413062.png

 

Give this a try.

Amount = SUMX ( 'Scrap Data (2)', 'Scrap Data (2)'[Weight] * RELATED ( 'Scrap Type Values (2)'[Value]) )
Anonymous
Not applicable

Thanks! But like i said i am a very new, can you remind me Where i put that?? LOL

 

You would click on Modeling > New Measure

jdbuchanan71_0-1594442982777.png

 

You should proably start with an intro to DAX and modeling, something like this.

https://www.sqlbi.com/p/introducing-dax-video-course/

 

Anonymous
Not applicable

Thanks for your help!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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