multiply tow columns from different tables

[Anonymous]

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!

[jdbuchanan71]

@Anonymous 

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

[Anonymous]

They are joined by Scrap Type Name:

[jdbuchanan71 · Accepted solution]

Give this a try.

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

[Anonymous]

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

[jdbuchanan71]

You would click on Modeling > New Measure

[jdbuchanan71]

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

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

[Anonymous]

Thanks for your help!