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.
Hello community, I hope somebody can help me with this calculation.
The result I’m expecting is to show the weighted average of the price variation.
I will show how can I do this on power pivot and how far I’m with power BI.
For this I will need:
1) The weighted average price by quarter.
2) The price variation between the vendor’s price and the average price by quarter.
3) And finally calculate the weighted average of those variations.
The Table
Excel
Power BI
Weighted Average Price = sum(Tabla1[Total])/sum(Tabla1[Amount (lb)])
-Total weighted average = CALCULATE (SUM ( Tabla1[Total]) / SUM ( Tabla1[Amount(lb)] ); ALL ( Tabla1[Vendor ] ))
-Variation = ([Weighted Average Price]-[-Total weighted average])/[-Total weighted average]
Here is where I got stack. I don’t know how to get the weighted average of those variations. At the beginning, I thought it was the total of the table, but it is not. The total on the table is a very different number.
Any ideas to solve this enigma?
Best
Solved! Go to Solution.
In this scenario, since you already put a measure into matrix, we can't define aggregation on a measure. And it's not possible to custom aggregation on Grand/Sub Total level.
For your requirement, it can't be achieved currently. Please vote a similar idea.
Regards,
In this scenario, since you already put a measure into matrix, we can't define aggregation on a measure. And it's not possible to custom aggregation on Grand/Sub Total level.
For your requirement, it can't be achieved currently. Please vote a similar idea.
Regards,
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 |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |