Calculate Moving Average

hi Anonymous ,

you may try to add a calculated column like:

Column = 
AVERAGEX(
    FILTER(
        data,
        data[Site]=EARLIER(data[Site])
            &&data[Date]<=EARLIER(data[Date])
    ),
    data[Value]
)

 it worked like:

Moving AVG = 
AVERAGEX(
    WINDOW(
        1, ABS,
        0, REL,
        DATA,
        ORDERBY( DATA[Date] ),
        DEFAULT,
        PARTITIONBY( DATA[Site] ),
        MATCHBY( DATA[Site], DATA[Date] )
    ),
    DATA[Value]
)