Joel on 14 Apr 2016 01:11:55
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.
- Comments (5)
RE: Weighted Average
Weighted average should also be a selection in Power Query grouping the values in a table. Currently, sums, non-weighted average, etc.
RE: Weighted Average
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]
RE: Weighted Average
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).
RE: Weighted Average
Also could do with other ttpes of trend line such as Power Exponential etc
RE: Weighted Average
Having a weight column would be a great addition.