Forum Discussion

Stan_Lego's avatar
Stan_Lego
Frequent Visitor
4 years ago
Solved

I don't know why I cannot use the Rolling Average Quick Measures

I am trying to plot the 7 Day rolling average of CT, but i am unable to do so for some reason using the quick measures. Can anybody help me, will really appreciate it. Thanks!   PBI File: https://d...
General Comment
Need Help
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Stan_Lego ;

    If you want to use rolling average base on [CheckInTime] , please try it.

    RoLL =
CALCULATE (
    AVERAGE ( [CT] ),
    FILTER (
        ALL ( TrackingTable ),
        DATEDIFF ( [CheckInTime], MAX ( [CheckInTime] ), DAY ) <= 6
            && DATEDIFF ( [CheckInTime], MAX ( [CheckInTime] ), DAY ) >= 0
    )
)

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Stan_Lego ;

If you want to use rolling average base on [CheckInTime] , please try it.

RoLL =
CALCULATE (
    AVERAGE ( [CT] ),
    FILTER (
        ALL ( TrackingTable ),
        DATEDIFF ( [CheckInTime], MAX ( [CheckInTime] ), DAY ) <= 6
            && DATEDIFF ( [CheckInTime], MAX ( [CheckInTime] ), DAY ) >= 0
    )
)

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Stan_Lego's avatar
Stan_Lego
Frequent Visitor
4 years ago

Hi v-yalanwu-msft 

 

Thank you for your help, i just wanna ask why doesn't the graph start from zero and instead it starts from a particular value. Is it possible to make the graph only calculate rolling average from the first date in the database based on check out?

 

Thanks again for the help