Cummulative sum by month and year

[Hanuma_Srikiran]

Hi,

Please anyone help on this.

The black bar is Actual INVENTORY Amount

The green bar is cummulative sum of it. It also summing the dec 2017 and jan 2018 also. i dont want continue for next year. The next Year should start from jan of that year.  The DAX which I used is
 Cummulative INVENTORY AMT =
CALCULATE (
    [INV_Amount],
    FILTER (
        ALL ( 'GENERALJOURNALENTRY' ),
        GENERALJOURNALENTRY[ACCOUNTINGDATE] <= MAX ( GENERALJOURNALENTRY[ACCOUNTINGDATE] )
    )
)

thanks.

[v-chuncz-msft · Accepted solution]

@Hanuma_Srikiran,

You may refer to the DAX below.

Measure =
VAR d =
    MAX ( GENERALJOURNALENTRY[ACCOUNTINGDATE] )
RETURN
    CALCULATE (
        [INV_Amount],
        FILTER (
            ALL ( 'GENERALJOURNALENTRY' ),
            GENERALJOURNALENTRY[ACCOUNTINGDATE] <= d
                && GENERALJOURNALENTRY[ACCOUNTINGDATE] >= DATE ( YEAR ( d ), 1, 1 )
        )
    )