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.
I am trying to create a calculated column where I simply multiply two values together originating from two different tables. The column should equal $ Adjustment multiplied by Unit Quantity to equal Commisson. My results are repeating rows with the same value, but they should be different. I have attached a screenshot of my DAX formula and the columns I am working with. Thanks!
Solved! Go to Solution.
Hi @CoopyJoe
Column expression:
measure expression:
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @CoopyJoe
Column expression:
measure expression:
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Write that formula as a calculated column formula (not a measure)
As @ribisht17 suggests, the RELATED function is likely useful here. Something like this:
RELATED ( Product[Quantity] ) * Commission[$ Adjustment]
This makes some assumptions about how the tables are related though, so I can't guarantee it'll work without seeing how your tables are structured and related to each other.
Please refer to this one Solved: DAX multiply two columns in separate tables - Microsoft Power BI Community
>>RELATED function
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
Hi,
The type of the columns are correct? (number)
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |