Forum Discussion

vincentakatoh's avatar
vincentakatoh
Icon for Helper IV rankHelper IV
8 years ago
Solved

Moving Range DAX (subtract previous row values from earlier DateTime)

Hi,  Need help with DAX to calculate "Moving Range".   TimeSPC- Time when values are measured.  MeasureValue- dimension in mm Moving Rane= Absolute difference between MeasureValue compare to ear...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    vincentakatoh

     

    Try this MEASURE

     

    Moving Range =
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] ) )
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    vincentakatoh

     

    Try this MEASURE

     

    MRBR = AverageX(ALLSELECTED(data1[TimeSPC]),[MovingRange])
MaxHsu09's avatar
MaxHsu09
New Member
7 years ago

@Zubair_Muhammad

I use this measurement and change as below
data1[TimeSPC]=EV269353069[MC_START_DATETIME] 
data1[MeasureValue]=EV269353069[Die placement X] 

MovingRangeX =

IF(ISBLANK(data1[EarlierTime]);blank();(

VAR EarlierTime = CALCULATE ( MAX ( EV269353069[MC_START_DATETIME] ); FILTER ( ALLSELECTED ( EV269353069[MC_START_DATETIME] ); EV269353069[MC_START_DATETIME] < SELECTEDVALUE (EV269353069[MC_START_DATETIME] ) ) )

VAR EarlierMeasureValue = CALCULATE ( SUM ( EV269353069[Die placement X] ); EV269353069[MC_START_DATETIME] = EarlierTime )

RETURN ABS ( EarlierMeasureValue - SUM ( EV269353069[Die placement X] ) ) ))

but it show "The ; syntax is wrong" in Powr BI
could you help me check ik?