Forum Discussion
Calculating STDEV for most Recent 12-Months
Microsoft Employee
In this scenario, you have to split all parts to get your "custom" std dev. Please refer to the solution in a similar thread below:
Regards,
v-sihou-msft Thank you for the info!! The link you provided helped out, but my senario is a bit different. In the example, the individule had to create his sample set by calculating the number of instances our ocurrances by multiplying the qty by frequency. For me, my sample set is the sum of sales in the month. In addiiton I include a date filter. Here is what I came up with, but its not working well. Can you provide any help? Take care!!
ST_DEV = CALCULATE(
Var x_sum = SUM(iContractsChargebacks[ChargebackUnits])
Var mean = DIVIDE(x_sum,6)
VAR dev_sq_sum = POWER(x_sum- mean,2)
return
SQRT(dev_sq_sum/6),
FILTER(ALL(DimDate),
DimDate[Month ID]<=MAX(DimDate[Month ID])-1 &&
DimDate[Month ID]>=MAX(DimDate[Month ID])-6
)
)