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 31Opening Balance 100.00 120.00 60.00Category of Expenses and revenues. -40,00 +20,00 - 90,00Category of Expenses and revenues. +60.00 -80.00 +20.00Closing balance 120.00 60.00 -10.00 att.

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] ) ) ) )

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

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

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=eyJrIjoiZDljMTlhMWYtYWQ5Yy00ODU1LWE1OTQtYjdjNmY4MjA2MTFhIiwidCI6IjMyMzlmYzZkLTdlZTUtNDU5Zi04N2UxLTkzMWJhMGVkYWEwNCIsImMiOjR9

Cash Flow | Microsoft Fabric Community

26 Replies

Greg_Deckler
Community Champion
9 years ago
Is what you are presenting the result that you want or the data that you are working with?
- RogerioTortosa
  Helper II
  9 years ago
  result I want
  - Greg_Deckler
    Community Champion
    9 years ago
    OK, then can you provide an example of your starting data?
- RogerioTortosa
  Helper II
  9 years ago
  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?
dkay84_PowerBI
Microsoft Employee
9 years ago
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
- RogerioTortosa
  Helper II
  9 years ago
  https://1drv.ms/u/s!Au1L5zHi1GMNlUKeatK8sp4eeOg0
  - dkay84_PowerBI
    Microsoft Employee
    9 years ago
    A PBIX file linked to your database will not help. Could you create a small Excel file with a subset of the data?
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)
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)

Forum Discussion

Cash Flow

26 Replies

Related content

Cash flow Dashboard

Cumulative Cash Flow By Week

Cash flow statement

Cumulative Cash Flow By Week - Next Year

Issue Building a Cash Flow Measure