Forum Discussion
Solved
Standard Deviation
hello, am new to power BI, and am trying to plot a levey jenning standard deviation chart on power BI, that shows a minimum of 20% and max of 30% deviation from both ends of the ideal concentrata...
Well, I was thinking something like:
Ideal = AVERAGE([Ideal Concentration]) Ideal20%Above = [Ideal]*1.2 Ideal20%Below = [Ideal]*.8
thanks. to create a measure for this what fomular should i use to achieve the % line
Greg_Deckler
Community Champion
Community ChampionWell, I was thinking something like:
Ideal = AVERAGE([Ideal Concentration]) Ideal20%Above = [Ideal]*1.2 Ideal20%Below = [Ideal]*.8