Forum Discussion

rsderby68's avatar
rsderby68
Icon for Resolver I rankResolver I
3 years ago
Solved

Monthly Rolling Average Headaches

Hello All,    I am stuck trying to figure out how to modify the rolling average quickmeasure to include monthly averages in my table, below.  When I created the quickmeasure, it is indeed averaging...
Help
  • ERD's avatar
    ERD
    3 years ago

    rsderby68 , please, change the measure:

    ID_rolling_avg =
VAR period = DATESBETWEEN ( 'Date'[Date], DATE ( 2022, 05, 15 ), MAX ( 'Date'[Date] ) ) 
RETURN
    IF ( MIN ( 'Date'[Date] ) <= TODAY (), CALCULATE ( [ID_avg], period ) )
rsderby68's avatar
rsderby68
Icon for Resolver I rankResolver I
3 years ago

Sorry for all the appending messages but here is the full table.  I think it is correct except I need to lock in a start date for the averages of may-2022 or 05/15/2022 if it can be that specific.  

 

 

ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
3 years ago

rsderby68 , please, change the measure:

ID_rolling_avg =
VAR period = DATESBETWEEN ( 'Date'[Date], DATE ( 2022, 05, 15 ), MAX ( 'Date'[Date] ) ) 
RETURN
    IF ( MIN ( 'Date'[Date] ) <= TODAY (), CALCULATE ( [ID_avg], period ) )