Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Moving average excluding weekends and holidays

I have a table within PowerPivot currently that tracks a count of customers through our sales pipeline. From (by sales location) first interaction to charged sale. So far, I’ve creates a moving 5 day...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

AlB Correct, I'm looking for the moving average by location and group. What additional would I need to add in order to have the average calculated for only working days?

 

Thanks!

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous

 

Hang on... the table that you are showing, the one with the data, does it include weekends, holidays, company holidays as well? If so, what is the value of [Daily Count] on those days? Is it a blank(), a valid value that you just want to ignore?  

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    AlB The table that I have listed up there only includes working days (everything but weekends and corporate holidays). 

    • AlB's avatar
      AlB
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Anonymous

       

      I'm getting a bit confused, sorry.

      Is that then the format of the table you'll be working with? It only has entries for weekdays that are not corporate holidays?

      Or is that just the case with the table that you listed? 

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        AlB

         

        Not a problem, thank you for the help so far!

         

        So the sales table that I listed in the first example, with the screenshot, does not include weekends or holidays. Essentially, I'm trying to find a way to do a moving average from a specific date and the four prior entries for a particular group. Hopefully this helps and clarifies. Let me know if you have any other questions.