Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
tabhowells
Regular Visitor

Calculating average of last 5 values

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!

 

 

1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft Employee
Microsoft Employee

@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,

 

View solution in original post

1 REPLY 1
v-sihou-msft
Microsoft Employee
Microsoft Employee

@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,

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.