Forum Discussion

RogerioTortosa's avatar
RogerioTortosa
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...
Need Help
fatherof4's avatar
fatherof4
Frequent Visitor
9 years ago

Is there a way to get the funds flow with the opening and closing on same visual? 

RogerioTortosa's avatar
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] ) ) ) )