cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
THEG72 Member
Member

Generating CashFlow Forecast Tables

I have the following Table data containing cash inflow timings and amounts

 

 

Table Data.JPG 

 

In the example above, it shows 8.2 units for 5 months @ $194,103 which equates to $1,591,645 per month span.

 

What is the recommended approach to Generate this series of forecast cash inflows using the table data i have?

 

 

Thanks for any help!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Generating CashFlow Forecast Tables

Hi @THEG72

 

You may create a month table like below first. Then link the two table.

1.png

 

You can get the table with measure like below:

Measure =
CALCULATE (
    SUM ( Table2[Forecast Monthly Revenue] ),
    FILTER (
        ALL ( Table2 ),
        Table2[Finish Date] >= MAX ( 'Month'[Month] )
            && Table2[Start Date] <= MAX ( 'Month'[Month] )
    )
)

1.png

Regards,
Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: Generating CashFlow Forecast Tables

Hi @THEG72

 

It seems you may try to use quick measure. Here are some articles for you. If it is not your case, please explain more about your expected output.

 

https://powerbi.microsoft.com/en-us/blog/quick-measures-preview/

http://www.inecta.com/power-bi-cash-flow-forecast-in-microsoft-d365-business-central

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
THEG72 Member
Member

Re: Generating CashFlow Forecast Tables

hi @v-cherch-msft


What i am after is the method to generate table data from the table information i have.

 

So in the first example Job T1S01, the table output would generate 5 cashflows (as the month span is 5 from Jan to May 2019) i need to generate in  table is as follows:

Cashflow Capture.JPGFirst Jobs Cashflow using Units per Month and Price Per Unit by Month Span

The Cashflow Amount and Dates takes into consideration the number of Monts the cashflow amount will span. The cashflow amount is simply the Units per Month Forecast multiply the Price per Unit

 

 

Community Support Team
Community Support Team

Re: Generating CashFlow Forecast Tables

Hi @THEG72

 

You may create a month table like below first. Then link the two table.

1.png

 

You can get the table with measure like below:

Measure =
CALCULATE (
    SUM ( Table2[Forecast Monthly Revenue] ),
    FILTER (
        ALL ( Table2 ),
        Table2[Finish Date] >= MAX ( 'Month'[Month] )
            && Table2[Start Date] <= MAX ( 'Month'[Month] )
    )
)

1.png

Regards,
Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.