CHill97402
New Member
- Joined
- Apr 22, 2014
- Messages
- 3
I am needing create a weighted standard deviation measure for a data set, and am having extreme difficulties determining how to achieve this with DAX.
We can assume a simple data structure, with the [Val] and [Wgts] columns holding the Values and Weights respectively.
Within Excel, assuming 'Vals' is a named range holding the values, and 'Wgts' is a named range holding the weights, the formula would be:
=SQRT(SUMPRODUCT(Wgts,((Vals-SUMPRODUCT(Vals,Wgts)/SUM(Wgts))^2))/SUM(Wgts)*COUNT(Vals)/(COUNT(Vals)-1))
How would I transcribe this into DAX?
We can assume a simple data structure, with the [Val] and [Wgts] columns holding the Values and Weights respectively.
Within Excel, assuming 'Vals' is a named range holding the values, and 'Wgts' is a named range holding the weights, the formula would be:
=SQRT(SUMPRODUCT(Wgts,((Vals-SUMPRODUCT(Vals,Wgts)/SUM(Wgts))^2))/SUM(Wgts)*COUNT(Vals)/(COUNT(Vals)-1))
How would I transcribe this into DAX?