Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |