Forum Discussion

marcmen's avatar
marcmen
Helper I
4 years ago
Solved

Amortization Balance

Hi All, I am looking for some help to create either a new column or a measure that will show a running balance based on the amortization script below.    Amortization HW = SUMMARIZE(filter(CROSSJO...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi marcmen ,

     

    You could create a measure to get the cumulative value for [HW CapEx].

    cumulativ_ = CALCULATE(SUM(AOPF[HW CapEx]),FILTER(ALLSELECTED(AOPF),AOPF[Date]<=MAX(AOPF[Date])))

     Then use the starting balance minus [cumulativ_].

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi marcmen ,

 

You could create a measure to get the cumulative value for [HW CapEx].

cumulativ_ = CALCULATE(SUM(AOPF[HW CapEx]),FILTER(ALLSELECTED(AOPF),AOPF[Date]<=MAX(AOPF[Date])))

 Then use the starting balance minus [cumulativ_].

 

Best Regards,

Jay

  • marcmen's avatar
    marcmen
    Helper I
    4 years ago

    Anonymous  - that worked  -  thank you