Creating cumulative (running) total for active contracts

[Anonymous]

Hi, I'm relatively new to DAX so any help would be appreciated. 

I have a contracts table with MRR, ContractedStartDate and ContractedEndDate. 

I need to create a table that would show a running total MRR of all contracts that are active during any given period of time. I also have a calendar table by which i would filter the date on the report. 

This is my approach:

Running total =

CALCULATE(

         SUM(Contracts[MRR]),

         FILTER(ALLSELECTED(Contracts),

          Contracts[ContractedStartDate] <=MAX(Contracts[ContractedStartDate])))

i think the last line is where im going wrong. im slightly confused how i should be filtering the date and whether i should be using the calendar table instead?

Thanks 

[amitchandak · Accepted solution]

@Anonymous , refer this blog

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970