Evaluate a measure for multiple dates

[Anonymous]

Hello,

I have a contract database containing basic contract information such as Contract number, Client name, contract value, contract signature date, contract start date and contract end date.

Our Company has contracts that vary in lenght so we use MRR as a way to compare all contracts on the same basis.

I am trying to obtain a line chart that would show the evolution of total Monthly recurring revenue (MRR) on a monthly basis for the past 3 years.

I am able to obtain the MRR at the current date with a measure that corresponds to this formula:

Current MRR (USD) = CALCULATE(SUM(Contract_Data[Contract MRR]),Contract_Data[Subscription Start Date]<TODAY(),TODAY()< Contract_Data[Subscription End Date])

In the above measure, [Contract MRR] is the following measure: 

Contract MRR = (DIVIDE(Contract_Data[Contract Value],Contract_Data[Contract Lenght],0))

I fell I could get to what I am looking for if I could only replace Today() in the above formula with a dynamic date so that the expression is evaluated for every month that I include in my report filter. Is there an easy way to do that?

In the end I would obtain something like this:

Thank you in advance for your precious help

[amitchandak · Accepted solution]

Check if this can help. You need only one date slicer.

https://medium.com/chandakamit/power-bi-comparing-data-across-date-ranges-36be49b68613

[Anonymous]

That worked thanks for the very quick turnaround.