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

    • fatherof4's avatar
      fatherof4
      Frequent Visitor
      9 years ago

      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.    

       

       

       

       

      • RogerioTortosa's avatar
        RogerioTortosa
        Helper II
        9 years ago

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

    • escolastico's avatar
      escolastico
      Regular Visitor
      9 years ago

      Rogerio, ficou muito bom seu Fluxo de Caixa. Teria como compartilhar um PBIX modelo?

      • RogerioTortosa's avatar
        RogerioTortosa
        Helper II
        9 years ago

        Hi, 

         

        The client does not allow the information to be released

        But follows tables and relationships

         

         

        Vlr Movi =
        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] ); ALLSELECTED(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] ); ALLSELECTED(dimTipFlu)
                    );
                    SUM ( fatMovi[vlrmovi] )
                )
            )
        )