Forum Discussion
KelvinMorel
Helper II
Helper IIInterest Rate -Weighted Average
Hi, I'm new to POWER BI, would like to calculate "Weighted Average" of salesmen but can't get around this, this sample of my data ACM RATE PERIODE WEIGHTED Salesman1 2,986 72 ...
The DAX-measure would look like this:
WAvg:=SUMX(Table1,Table1[RATE]*Table1[PERIODE])/SUM([PERIODE])
here is how it works:
https://powerpivotpro.com/2012/05/weighted-averages-another-use-of-sumx/
Ashish_Mathur
Super User
Super UserHi,
Try this
=SUMX(Data,Data[Rate]*Data[Periode])/COUNTROWS(Data)
KelvinMorelHelper II
Helper IIHi Ashish_Mathur,
ImkeF solution is the sintax I was looking for but maybe yours can help out in the future, how do I need to read/understand that?
Many thx