Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
1,025
Views
Topic starter
What is the best way in Power Pivot to calculate a weighted average? i.e. weight column A's values using column B's values = ∑Ai*Bi/∑Bi for whatever segment/slice is visible
Posted : 12/06/2021 12:12 pm
Hi Edward,
Use the SUMX function to iterate over the rows in the underlying table based on the filters.
Mynda
Posted : 13/06/2021 2:02 am