Help to find Standard Deviation

Question

Hello Team,&nbsp;I've to&nbsp;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 Deviation for the same.&nbsp;Thanks,Siva&nbsp;

greg_deckler · Answer

If 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:

https://community.powerbi.com/t5/Data-Stories-Gallery/Ohio-Primary-and-Secondary-Education-Performance/td-p/74155

Should be able to download the PBIX and see how I did it.

sivamani · Answer

Thank you&nbsp;so much,&nbsp;Greg_Deckler.&nbsp;Hope it will help me.

greg_deckler · Answer

Looks like I just used STDEV.P function&nbsp;Overall Score District StdDev = STDEV.P(DISTRICT[OVERALL SCORE])&nbsp;https://msdn.microsoft.com/en-us/library/gg492207.aspx&nbsp;&nbsp;

sivamani · Answer

Greg_Deckler,&nbsp;Thank you!&nbsp;The challenge&nbsp;here is I need to find standard deviation for a measure which is a quick measure to calculate 3 months rolling average.&nbsp;&nbsp;I think the solution would be creating it as a calculated measure. Is it possible?&nbsp;

greg_deckler · Answer

Ah, it sounds like you are trying to do an aggregation. The trick there is to use SUMMARIZE. See this article:&nbsp;https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149&nbsp;A quick measure still creates a real measure, it just does it quickly without you having to hand-type the DAX code.

Forum Discussion

Help to find Standard Deviation

9 Replies

Related content

Standard Deviation

Standard Deviation DAX

Standard Deviation of total sales

Standard Deviation

Standard Deviation