Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Spread project value evenly accross project duration

Essentially i have a table similar to below:   Project Start End Value Revenue Shape ABC 01/02/2020 01/04/2022 $100,000,000.00 Flat ZYX 01/01/2018 01/02/2029 $310,000,000.00 Fl...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.  I changed the start and end dates to check my result.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Share the download link of your PBI file, explain the question and show the expected result.

lbudack's avatar
lbudack
Icon for Advocate III rankAdvocate III
4 years ago

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. 

 

https://schmidtassociates-my.sharepoint.com/:u:/g/personal/lbudack_schmidt-arch_com/EUswp4Rquf1Cm7xge71CDI4BcNIOicErVc1RM6RPiMELnA?e=KMSbVp 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    I cannot understand your requirement at all.