Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |