Forum Discussion
Martin-Prague
8 years agoHelper II
DAX, Disaggregate PLAN data - start date, end date
Hello Comunity, I have source data in this structure: Campaign ID Start date End date Plan
888405244 01.01.2016 31.12.2016 726190
888405244 01.01.2017 31.12.2017 890145
873145821 01.01.2...
- 8 years ago
Vvelarde
8 years agoCommunity Champion
- bbqq0215 years agoFrequent Visitor
Hi Vvelarde
Thanks for your solution, it works really well.
I would like to add some additional functionality, instead of spreading a task evenly over the days between the start and end i only want to spread it over week days. My second step would only spread it over working days (excluding bank holidays).
I anticiapte the steps to be:
Count the week days between end and start and divide task resouces by this
Apply this daily quantity to just the week days
Can you give me some pointers on how to achieve this? I do have date tables which include week days or working days however the modifications you are making are in the pre-processing stage. I am not sure how to incorporate them.
Thanks
Will