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 ,

 

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

ChristyQV's avatar
ChristyQV
Frequent Visitor
5 years ago

Works like a charm and is easier than the path that I was on.  Thanks so much.