Forum Discussion

CanadaMGB's avatar
CanadaMGB
Frequent Visitor
9 years ago
Solved

Running Total that includes calculations based on prior amount

Is it possible to produce a running total in DAX that includes calculations based off the previous running total balance? My thinking is no, but after researching it I couldn't find a definitive answ...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    CanadaMGB,

     

    I have tested it on my local by using the sample data below.

    Then create a calculated column
    Rate = IF(ISBLANK(Table2[Churn%]),400,1-Table2[Churn%]+Table2[New%])

    And create a measure
    Measure 2 = CALCULATE(PRODUCTX(Table2,Table2[Rate]),FILTER(ALL(Table2),Table2[Date]<=MAX(Table2[Date])))

     

    Result

     

    Regards,

    Charlie Liao

CanadaMGB's avatar
CanadaMGB
Frequent Visitor
9 years ago

v-caliao-msft  That's awesome, thanks Charlie!