Measure - moving/rolling average

[AdamMG]

Hi Everyone.
I am trying to create a measure (must be measure) - moving/rolling average (2 or 5 results) for DupResult column.

My Table looks like

rowid	DupResult	OrigResult
213034	8.97	7.29
215470	7.88	9.81
219651	7.97	6.32
225171	7.62	9.91
233214	9.14	12.45
233264	8.62	11.75
238295	6.33	8.98

Please help

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

INDEX function (DAX) - DAX | Microsoft Learn

WINDOW function (DAX) - DAX | Microsoft Learn

2 rows moving avg DupResult: =
VAR _previousrow =
    MAXX (
        OFFSET (
            -1,
            ALL ( data ),
            ORDERBY ( data[rowid], ASC ),
            ,
            ,
            MATCHBY ( data[rowid] )
        ),
        data[rowid]
    )
VAR _t =
    WINDOW (
        -1,
        REL,
        0,
        REL,
        ALL ( data ),
        ORDERBY ( data[rowid], ASC ),
        ,
        ,
        MATCHBY ( data[rowid] )
    )
RETURN
    IF (
        _previousrow <> BLANK ()
            && HASONEVALUE ( data[rowid] ),
        AVERAGEX ( _t, data[DupResult] )
    )

[AdamMG]

Hi @Jihwan_Kim 
Thank you very very much 😉