Forum Discussion
Spread project value evenly accross project duration
Hi,
You may download my PBI file from here. I changed the start and end dates to check my result.
Hope this helps.
Super UserHi,
You may download my PBI file from here. I changed the start and end dates to check my result.
Hope this helps.
Advocate IIIAshish_Mathur Hi, Ashish! This solution proved very useful for something I'm working on, but occasionally I'm getting duplicate rows. Instead of revenue, I'm spreading labor forecasts through projects with multiple phases & dates so that may be why. I can't find where that's happening in the calculations. Any ideas or do I need to put my data here?
- Ashish_Mathur
Hi,
Share the download link of your PBI file, explain the question and show the expected result.
- lbudack
Ashish_Mathur Sorry for the delay - it took me a while to format everything and get it out of my test files! Here's the link to the test file. One table is the current state, and the other is the desired state. What I am aiming to do is take phases of a project with different start and end dates and evenly spread out the projected labor across resources.
- Ashish_Mathur
Hi,
I cannot understand your requirement at all.