Forum Discussion

Mafia7759's avatar
Mafia7759
New Member
7 years ago

Help with Cash Flow Projection

Hello,

 

I'm trying to do something i know how to do in excel. It's a cash flow projection from monthly installments or payments. Want to do it in PowerBi. Here is the information i have. I already have all the information I need to do it : The date when you do the payments, the amount you pay and the remaining payments. 

 

 

You only use 3 columns marked in black. The date of last payment, the payment that you will replicate "Saldo1" , and the payments that are remaining that is the last column.

 

Thank you in advance.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Mafia7759,

     

    Maybe you can consider to add a measure to calculate out original cash volume. Then you can create a line chart of cashflow changes based on 'date' and grouped by different 'No.' (calendar date as axis, unique No. column as legend, calculated current cash volume measure as value)

     

    If above not help, can you please share some sample data with expected result for test and coding formula?


    Regards,

    Xiaoxin Sheng