View My Drafts
What do you mean by MRR?
The data presentation is quite confusing as how you distribute the MRR of 10,000 in case 1. The value in revenue exceed 10,000 from Dec-Mar i,e, 2.5K + 7.5K + 10K + 10K = 30K.
For how long the monthly revenue will exist? Let say case 1, you have 1st 4 months but there is still a value on 5th month? When it will stop?
You can directly work on power query to generate the series required. Check the attached file and view it in power query and check the query steps.