Forum Discussion

Hanuma_Srikiran's avatar
Hanuma_Srikiran
Frequent Visitor
8 years ago
Solved

Cummulative sum by month and year

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 ye...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    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 )
        )
    )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

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