Forum Discussion
SivaMani
Resident Rockstar
Resident RockstarHelp 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...
Greg_Deckler
Community Champion
Community ChampionIf you created the average as a quick measure, it should give you the formula still.
Check out my post on Primary and Secondary School Performance for Ohio. It includes the PBIX file and the calculation of standard deviation was central to the project:
Should be able to download the PBIX and see how I did it.
SivaMani- Greg_Deckler
Looks like I just used STDEV.P function
Overall Score District StdDev = STDEV.P(DISTRICT[OVERALL SCORE])
https://msdn.microsoft.com/en-us/library/gg492207.aspx
- SivaMani
Thank you!
The challenge here is I need to find standard deviation for a measure which is a quick measure to calculate 3 months rolling average.
I think the solution would be creating it as a calculated measure. Is it possible?