Wanted to get Cumulative Total by Financial Year

[sathishsam]

I followed the topic https://community.powerbi.com/t5/Desktop/Cumulative-sum-that-resets-every-year/td-p/994086 and created a measure, however, i am seeing a different result. Can someone please help. I just want a cumulative total by Date or Year and rest every Year

[sathishsam]

Thank you so much!

[Jihwan_Kim · Accepted solution]

Hi,

I assume you want to create a calculated column.

Please try the below for creating a new column in the same table.

Calculated Column CC =
SUMX (
    FILTER (
        'Sheet1',
        'Sheet1'[Year] = EARLIER ( 'Sheet1'[Year] )
            && 'Sheet1'[Date] <= EARLIER ( 'Sheet1'[Date] )
    ),
    'Sheet1'[Headcount]
)