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.
I have the following Table data containing cash inflow timings and amounts
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!
Solved! Go to Solution.
Hi @THEG72
You may create a month table like below first. Then link the two table.
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] ) ) )
Regards,
Cherie
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
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:
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
Hi @THEG72
You may create a month table like below first. Then link the two table.
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] ) ) )
Regards,
Cherie
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |