Calculating average of last 5 values

[tabhowells]

I am bringing in streaming data from a machine into PowerBI. I would like to take the last 5 values and create a rolling average of those last 5 values to populate into a visualization.

Time      Value   Rolling Average

0920      5

0915      6

0910      5

0905      7

0900      5

Rolling Average at 0920 = 5.60

Thanks!

[v-sihou-msft · Accepted solution]

@tabhowells

I suggest you add an index column in your table. Then you can create a measure like below:

Last 5 Average =
CALCULATE (
    SUM ( Table[Value] ),
    FILTER (
        ALL ( Table ),
        Table[Index] <= MAX ( Table[Index] )
            && Table[Index]
                > MAX ( Table[Index] ) - 5
    )
)

Regards,