Running Total based on Funding Year

[mvgust]

I've got a data source with a funding ID and I need to create a column with the running total.  See below for an example.

How would I create the running total column?

FundingID	Funding Year	Amount	Running Total
4555	2019	1000	1000
4555	2020	2000	3000
4555	2021	3000	6000

[v-xiaotang]

Hi @mvgust 

Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
really appreciate!
Any question, please let me know. Looking forward to receiving your reply.

Best Regards,

Community Support Team _Tang

[v-xiaotang · Accepted solution]

Hi @mvgust 

if you need to classify by id then sum total, try this

 CALCULATE(SUM('Table'[Amount]),FILTER(ALLEXCEPT('Table','Table'[FundingID]),'Table'[Funding Year]<=MIN('Table'[Funding Year])))

 result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[ChrisMendoza]

Is this what you mean?

Measure :=
VAR _year =
    MAX ( TableName[Funding Year] )
RETURN
    CALCULATE ( SUM ( TableName[Amount] ), TableName[Funding Year] <= _year )