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
Well, I was thinking something like:
Ideal = AVERAGE([Ideal Concentration]) Ideal20%Above = [Ideal]*1.2 Ideal20%Below = [Ideal]*.8
thank you so much for the answer, i also have a situation that i would like to implement a flag if any of the sample concentration exceeds 30% above and 30% below an email should be sent notifying me of the sample that is out of range. thanks you