Forum Discussion

ChristyQV's avatar
ChristyQV
Frequent Visitor
5 years ago
Solved

Calculated table or column with a rolling average

Dear GURUS!  Please help! I have a data set like below, with the result I'm working towards: Date WellCode RunHours   Desired column- 3 Day Running Avg Criteria Result 4/29/2021 BN_WP0...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi ChristyQV ,

     

    Try using this formula to calculate the average value.

     

    Column = CALCULATE(AVERAGE('FactPumpageDaily'[RunHours]),FILTER(ALLEXCEPT('FactPumpageDaily','FactPumpageDaily'[WellCode]),'FactPumpageDaily'[Date]>EARLIER('FactPumpageDaily'[Date])-3&&'FactPumpageDaily'[Date]<=EARLIER('FactPumpageDaily'[Date])))

     

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi ChristyQV ,

 

If "Desired column- 3 Day Running Avg" is the result you want, I just can't figure out how did you get it by "RunHours". Please correct me If I misunderstand your meaning.

 

Best regards,

Jay