Forum Discussion

mvgust's avatar
mvgust
Icon for Helper III rankHelper III
5 years ago
Solved

Running Total based on Funding Year

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...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    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's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Is this what you mean?

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