Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
Give this a try.
Amount = SUMX ( 'Scrap Data (2)', 'Scrap Data (2)'[Weight] * RELATED ( 'Scrap Type Values (2)'[Value]) )
@Anonymous
How are the two table joined together? Can you show a picture of the model view (tables and join arrows)?
They are joined by Scrap Type Name:
Give this a try.
Amount = SUMX ( 'Scrap Data (2)', 'Scrap Data (2)'[Weight] * RELATED ( 'Scrap Type Values (2)'[Value]) )
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
You should proably start with an intro to DAX and modeling, something like this.
https://www.sqlbi.com/p/introducing-dax-video-course/
Thanks for your help!
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |