Forum Discussion
Help to find Standard Deviation
Hello Team, I've to calculate Standard Deviation for Rolling 3 months average sales. Unfortunately, I created the average as a quick measure. I'm looking for suggestions to calculate Standard Dev...
Right, so that article shows the use of SUMMARIZE, so you put your grouping and your measure into the SUMMARIZE. This essentially turns the measure into a column in the context of the table coming back from SUMMARIZE and then you can use whatever aggregation on that. In your case you would want to use the STDEVX.P function. Note the "X".
I tried the same. Unfortunately, I got the following warning,
A circular dependency was detected
SivaMani,
Please take a look at the following blog and similar thread about how to calculate standard deviation of a measure.
Standard Deviation Demystified in Power Pivot
Calculating standard deviation of the calculated measure
Regards,
Lydia