It would be great if there was a way to create a weighted average. For example, if you have units and prices which vary, it would be great to have a quick and easy way to create a weighted average price when you slice the data. It would basically be a sumproduct of the units and prices divided by the sum of the products.
6 Comments
- Having a weight column would be a great addition.
- Also could do with other ttpes of trend line such as Power Exponential etc
- Weighted average interest rate would be great for us. You would need to be able to specify what you were weighting by (eg face value or market value).
- You can already do this with simple DAX statements. Similarly to the idea of SUMPRODUCT in Excel, you can use SUMX([col1]*[col-weights])/sum[col-weights]
Weighted average should also be a selection in Power Query grouping the values in a table. Currently, sums, non-weighted average, etc.
- Status added:Needs Votes
