Forum Discussion
Cash Flow
I went through this link
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
Is there a way to get the funds flow with the opening and closing on same visual?
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] ) ) ) )
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?
Please let me know if this is possible and how we could get it to work.
Thank you
