Forum Discussion

RogerioTortosa's avatar
9 years ago
Solved

Open Balance e Final Balance daily

Hi,   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 (x...
  • v-jiascu-msft's avatar
    9 years ago

    Hi, RogerioTortosa

     

     

    Please try this mearsure "test". I used the two columns "open_bank" and "close_bank" of table "dimTipFlu" as feature. You can try this directly.

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