Need help on DAX to calculate Average for below measure.
DAX for the measure is below.
MovingRange = IF(ISBLANK(data1[EarlierTime]);blank();( VAR EarlierTime = CALCULATE ( MAX ( data1[TimeSPC] ); FILTER ( ALLSELECTED ( data1[TimeSPC] ); data1[TimeSPC] < SELECTEDVALUE ( data1[TimeSPC] ) ) ) VAR EarlierMeasureValue = CALCULATE ( SUM ( data1[MeasureValue] ); data1[TimeSPC] = EarlierTime ) RETURN ABS ( EarlierMeasureValue - SUM ( data1[MeasureValue] ) ) ))
End goal is to calcuate Sigma, = MRbar/1.128.
- MRbar= Average of Moving Range.
- 1.128 is a constant.
Sample Pbix file
Solved! Go to Solution.