Forum Discussion
Solved
Interest 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/
Hi,
Try this
=SUMX(Data,Data[Rate]*Data[Periode])/COUNTROWS(Data)
Hi 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