Forum Discussion

Helper II

9 years ago

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

Anonymous

Not applicable

9 years ago

Hi RogerioTortosa

Check if this link is of help

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

Cheers

CheenuSing

Anonymous
Not applicable
9 years ago
Hi RogerioTortosa

I went through this link
https://www.powerpivotpro.com/2010/06/building-a-cash-flow-statement-in-powerpivot-using-dynamic-measures-in-dax/

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
- RogerioTortosa
  Helper II
  9 years ago
  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)
- fatherof4
  Frequent Visitor
  9 years ago
  Is there a way to get the funds flow with the opening and closing on same visual?
  - RogerioTortosa
    Helper II
    9 years ago
    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] ) ) ) )