Statistical process control chart

[LaurenceSD]

Hi,

I need to create a Statistical process control chart & I'm struggling to get the Standard Deviation of a measure in order to create the Upper and Lower Control Limits - all the Standard Deviation formulas I've found are for columns rather than measures - is it possible to do this for a measure? Below is my graph, and I'd like to use the Rolling & Day Average line as my average and so the upper and lower controls lines should flow from them. Any help achieving this would be great. Thanks

[amitchandak · Accepted solution]

@LaurenceSD , You can have Standard Deviation in power bi https://www.youtube.com/watch?v=ekcrlfZyAhg

https://docs.microsoft.com/en-us/dax/stdev-p-function-dax

That you can add and subtract from your measure

final measure you need is not very clear to me