Forum Discussion
Cash Flow
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
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.