Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculating 28day Rolling Average for Run Time

Hi,   I used this formula to calculate AVG run-time: ------------------------------------------------------------------- AVG RunTime(secs) = AVERAGEX( 'Run Time', DATEDIFF('Run Time'[StartTim...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , Join start or end date with the date of date table and try (Date without time stamp)

     

    Rolling 28 = CALCULATE(AVERAGEX( 'Run Time',
    DATEDIFF('Run Time'[StartTime],'Run Time'[EndTime],SECOND)
    ),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-28,DAY))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , Join start or end date with the date of date table and try (Date without time stamp)

 

Rolling 28 = CALCULATE(AVERAGEX( 'Run Time',
DATEDIFF('Run Time'[StartTime],'Run Time'[EndTime],SECOND)
),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-28,DAY))