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

## Re: Cash Flow

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

## Re: Cash Flow

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

## 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?

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

Highlighted
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?

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

Highlighted
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?

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

## 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:

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

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

Thank  you

Highlighted
Helper II

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.

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Experience what’s next for Power BI

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

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021