cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
peterso
Helper II
Helper II

Distribution Help

Hi everyone,

 

Hoping you can assist with this distribution, i'll do my best to explain. 

 

I'd like to distribute cost by month in such a way where it's cumulative(?) on the graph until the cost reaches it's end date, essentially ignoring the start date. When the end date is reached, the cost drops off.

 

For example, Jan 2018 would have $16,000 in cost (sum of project costs for all projects) and Mar 2021 would have $15,000 in cost (sum of project costs minus project A, since the end date has passed (1/30/2021).

 

Below is the table and I have a date table as well.

 

Distribution.PNG

 

Thank you in advance.

1 REPLY 1
amitchandak
Super User IV
Super User IV

@peterso , Not getting your number. Check Page 2 and table 3



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors