Forum Discussion
Standard Deviation
Hello, I'm having trouble getting the correct Standard Deviation from a dataset. Here's a subsection of a datset I'm working with: Week Ending Site SKU Nbr Units 1/6/2019 Sycamore 100...
Thanks Nick! I was actually looking for the Standard Deviation of the weekly average for each SKU. I created the measure:
Avg. Units per Week = SUM('Summarized Orders'[Total])/CALCULATE(DISTINCTCOUNT('Summarized Orders'[Calendar Week End]))
This gets me the correct avg. per week for each SKU when put into a visiual. Now I need to know what is the standard deviation of the weekly avg. "On average we sell X amount of 207585 per week with a standard deviation of Y"
Hi mweber ,
I'm a little confused about your requirement.
It seems that the solution of Nick_M should be helpful.
What is your desired output based on your data sample?
Best Regards,
Cherry