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
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous

 

Do you want the moving average per [Sales Location]  and [Group]? Cause I see you have the ALLEXCEPT for those two columns

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?