cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User I
Super User I

Re: Cash Flow

Hi @RogerioTortosa

 

Check if this link is of help 

 

http://pakaccountants.com/cash-flow-summary-excel-pivot-tables-multiple-worksheets/

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Highlighted
Super User I
Super User I

Re: Cash Flow

Hi @RogerioTortosa

 

I went through this link 

https://www.powerpivotpro.com/2010/06/building-a-cash-flow-statement-in-powerpivot-using-dynamic-mea...

 

and it worked for me without any errors.

 

The only caveat is the funds flow is separate and the opening and closing is separate visuals.

 

If this works for you please give KUDOS.

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Highlighted
Helper II
Helper II

Re: Cash Flow

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?

 

fig_2.png

 

 

 

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

 

 

 

 

 

 

 

Highlighted
Helper II
Helper II

Re: Cash Flow

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?

fig_2.png

 

 

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

 

 

Highlighted
Helper II
Helper II

Re: Cash Flow

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?

fig_2.png

 

 

 

 

Highlighted
Frequent Visitor

Re: Cash Flow

Is there a way to get the funds flow with the opening and closing on same visual? 

Highlighted
Helper II
Helper II

Re: Cash Flow

yes, it possible

 

Test = if ( DAY ( MIN ( dimCalendario[data] ) ) = 1; if ( MIN ( dimTipFlu[Open_Bank] ) = 1; SUM ( fatMovi[vlrmovi] ); IF ( MIN ( dimTipFlu[Close_Bank] ) = 1; CALCULATE ( SUM ( fatMovi[vlrmovi] ); ALL ( dimTipFlu ) ); SUM ( fatMovi[vlrmovi] ) ) ); IF ( MIN ( dimTipFlu[Open_Bank] ) = 1; CALCULATE ( TOTALMTD ( SUM ( fatMovi[vlrmovi] ); PREVIOUSDAY ( dimCalendario[data] ) ); ALL ( dimTipFlu ) ); IF ( MIN ( dimTipFlu[Close_Bank] ) = 1; CALCULATE ( TOTALMTD ( SUM ( fatMovi[vlrmovi] ); dimCalendario[data] ); ALL ( dimTipFlu ) ); SUM ( fatMovi[vlrmovi] ) ) ) )

Highlighted
Frequent Visitor

Re: Cash Flow

Using the data set for this link:

 

https://www.microsoft.com/en-us/download/details.aspx?id=38838

 

How could I create a cash flow flow similar to the picture shown below with Power BI?

 

 

 

Example.JPG

 

Please let me know if this is possible and how we could get it to work.

 

Thank  you 

Highlighted
Helper II
Helper II

Re: Cash Flow

Highlighted
Frequent Visitor

Re: Cash Flow

Thank you Rogerio.  Looks pretty close.  How did you structure the dax to show the start balance and end balance?  The end balance from one column should be the the start balance on the next.    

Cashflow.JPG

 

 

 

 

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