Forum Discussion
Solved
Rolling Total between Contract Dates
Hello, I'm looking for a solution to calculate a running total with a few wrinkles. Total Area of the facility = 4,500 Tenant 😧 When a contract expires, the formula in the backing data automatic...
butabara808 Sorry, I missed an important part in my DAX.
In Step 3, please use the following instead.
Running Area = CALCULATE(SUM('Table'[Area]),FILTER(ALLSELECTED('Table'),MAX('Date'[Date])>='Table'[Lease Start]))- CALCULATE(SUM('Table'[Expired Area]),FILTER(ALLSELECTED('Table'),'Table'[Lease End]<=MAX('Date'[Date])))* Also editted the original post for easy referecne.
butabara808 Sorry, I missed an important part in my DAX.
In Step 3, please use the following instead.
Running Area = CALCULATE(SUM('Table'[Area]),FILTER(ALLSELECTED('Table'),MAX('Date'[Date])>='Table'[Lease Start]))-
CALCULATE(SUM('Table'[Expired Area]),FILTER(ALLSELECTED('Table'),'Table'[Lease End]<=MAX('Date'[Date])))
* Also editted the original post for easy referecne.
Amazing stuff johnyip !!
I have a few more additional questions. Would it be better to start a new thread? Do you accept tips? 🙂
what tips?