PowerPivot Weighted Average

[gavs73]

Hi, would appreciate any help on this, I want to get a weight on groups of rows in my Data using PoverPivot.

So for example, the weight by Customer by Product in January.

This sort of structure, but obviously a lots more rows !

Is it possible to sum the Amount column by row using variables from within each row ?, I tried to use sumx but couldn't get it to work.

Thanks in advance for your help. Gav

Customer	Product	Month	Amount	Weighted Value
A	1​	Jan	5​	sum of all product 1 in Jan
A	2​	Jan	10​	sum of all product 2 in Jan
B	1​	Jan	5​	sum of all product 1 in Jan
A	2​	Feb	10​	sum of all product 2 in Feb
C	3​	Jan	8​	sum of all product 3 in Jan
D	3​	Feb	8​	sum of all product 3 in Feb
E	2​	Mar	10​	sum of all product 2 in Mar

​

​

 

[gavs73]

In Excel it would be this, but can it be done in PowerPivot / DAX ?

 

[sandy666]

maybe

DAX – Weighted Averages: Another Use of SUMX() - P3 Adaptive

Another Question from the Mr. Excel Forums Got a question on the forums the other day. It took some extra twists and turns but the simplest version of the question is worth covering here: how do I perform a weighted average?

powerpivotpro.com