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

Hi Anonymous

Have a look at this for a nice explanation on how to do it.

Cheers

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
7 years ago

That's an interesting approach, but you have to be careful generalizing it. Indexing the workdays is a good idea, but I'd recommend doing the indexing on your dedicated date table rather than trying to deal with ranking duplicate dates in your fact table.

 

Another approach would be to use the TOPN function as I suggested here.