Forum Discussion
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...
I guess your right. How would I go about doing that within DAX? Is there an expression I'm missing here, or just a total mental block?
Thanks!
- AlexisOlson
Super User
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.
