Cash Flow

[RogerioTortosa]

have a doubt that I still can not solve by watching your classes.
 
How do you set up a type of cash flow in PBI?

Example:
Tables: Calendar, Initial and Monthly Balance of the Bank Account, Daily Financial Movement

                                                            Day 1     day 2      day 3 ..... day 31

Opening Balance                                  100.00    120.00      60.00
Category of Expenses and revenues.       -40,00   +20,00 -    90,00
Category of Expenses and revenues.      +60.00    -80.00    +20.00
Closing balance                                    120.00     60.00     -10.00

att.

[Greg_Deckler]

Is what you are presenting the result that you want or the data that you are working with?

[RogerioTortosa]

In the Zip file = pbix e data source (xlsx)

How to calculate the final balance on 01/01/2017?
How to calculate the opening balance on 02/01/2017, what is the final balance on 01/01/2017?

[RogerioTortosa]

result I want

[Greg_Deckler]

OK, then can you provide an example of your starting data?

[RogerioTortosa]

Any news about this subject?

[RogerioTortosa]

https://app.powerbi.com/groups/me/dashboards/56211df1-2943-4c78-a937-041570b9a0a3

<iframe width="933" height="700" src="https://app.powerbi.com/view?r=eyJrIjoiZDljMTlhMWYtYWQ5Yy00ODU1LWE1OTQtYjdjNmY4MjA2MTFhIiwidCI6IjMyMzlmYzZkLTdlZTUtNDU5Zi04N2UxLTkzMWJhMGVkYWEwNCIsImMiOjR9" frameborder="0" allowFullScreen="true"></iframe>

https://app.powerbi.com/view?r=eyJrIjoiZDljMTlhMWYtYWQ5Yy00ODU1LWE1OTQtYjdjNmY4MjA2MTFhIiwidCI6IjMyM...