cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Cash Flow

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.

26 REPLIES 26
Highlighted
Super User IX
Super User IX

Re: Cash Flow

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper II
Helper II

Re: Cash Flow

result I want

Highlighted
Super User IX
Super User IX

Re: Cash Flow

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper II
Helper II

Re: Cash Flow

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...

Highlighted
Helper II
Helper II

Re: Cash Flow

Any news about this subject?

Highlighted
Microsoft
Microsoft

Re: Cash Flow

Power BI is more for creating dashboards.  While DAX is great for creating measures and can do a lot, in your example it might be easier to do the cash flow in excel and just import the data to Power BI to show as a table.  Power BI is not as flexible for creating cell by cell calculations.  

 

However, if you could provide a small sample of your data (anonymized if necessary) we can try to help with a solution

Highlighted
Helper II
Helper II

Re: Cash Flow

Highlighted
Microsoft
Microsoft

Re: Cash Flow

A PBIX file linked to your database will not help.  Could you create a small Excel file with a subset of the data?

Highlighted
Helper II
Helper II

Re: Cash Flow

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors