Forum Discussion
peterso
Helper II
Helper IIDAX help with strange distribution
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...
Hi, peterso
You can do like this. Create a date table, don't create relationships, and create a measure to calculate the desired result.
Like this:
Date Table = CALENDAR(MIN('Table'[Start Date]),MAX('Table'[End Date]))Measure = SUMX(FILTER(ALL('Table'),[End Date]>MIN('Date Table'[Date])),[Cost])If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super Userpeterso ,Not getting your number. Check Page 2 and table 3
petersoHelper II
Helper IIHi - I think maybe it would help to entirely ignore the start date.
Essentially this distribution ignores the start date. It assumes all projects are started as as long as the end date is not past today's date.
Once the end date for a project has passed, the project costs drop off.