Forum Discussion
Resident RockstarHelp to find Standard Deviation
Resident Rockstar
Community ChampionLooks 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?
- Greg_Deckler
Ah, it sounds like you are trying to do an aggregation. The trick there is to use SUMMARIZE. See this article:
https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
A quick measure still creates a real measure, it just does it quickly without you having to hand-type the DAX code.
- SivaMani
I'm Sorry. I think I didn't make it clear.
My problem is, STDEV.P expects column to calculate. But I have it as a measure which I need to find Std Dev.
Let's say,
I wanted to calculate Standard deviation for rolling month average. But it is actually a measure. So I'm unable to use it in STDEV.P().
Is there a way to calculate rolling N month average as a calculated column?
Kindly help me!