Cashflow presentation

[Anonymous]

Hi all, 

I have a dataset connected to the project online and schedule including many tasks. I am trying to make a monthly cashflow graph but I don't know how to split the costs between months. please see the below 

for an example 

I have this table. imaging the cost has been distributed equally in days. for example Task B each day has 40,000$. 

Task name	Start Date	Finish Date	Cost
A	10/02/2021	30/03/2021	$1,000,000
B	1/04/2021	20/04/2021	$800,000
C	15/04/2021	12/05/2021	$400,000

How can I show monthly cashflow??

[v-xulin-mstf · Accepted solution]

Hi @Anonymous,

If this meet your need:

Here is the demo, please try it: Cashflow presentation

Best Regards

Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for that, I commented on that post 

[amitchandak]

@Anonymous , refer my blog on a similar topic can help

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785

Also find attached find for allocation approch