Forum Discussion
Solved
Running total by group
Hey guys, I'm trying to do a rolling cumulative capital by loan as follows: schdule Loan Principal DueDate RT REQUIRED! 1 1abc 300 1/1/2022 300 2 1abc 300 2/1/2022 600 3 1...
Solved. thanks all
Column = CALCULATE(SUM(loanschedules[principal]), FILTER(ALLEXCEPT(loanschedules,loanschedules[_loan]), loanschedules[Date.1] <= EARLIER(loanschedules[Date.1])))
Solved. thanks all
Column = CALCULATE(SUM(loanschedules[principal]), FILTER(ALLEXCEPT(loanschedules,loanschedules[_loan]), loanschedules[Date.1] <= EARLIER(loanschedules[Date.1])))