This content has been marked as final. Show 2 replies
1 of 1 people found this helpful
Hello Forum, I would like to explain better my question:
- The attached Excel file shows the data: 10 units with different RFS (ready for service) dates which starts the rental MRR
- I tried to build the axis of time through blending or left join with a column of Dates (Fechas)
- I got the axis of time through SQL customized.
Issues i have:
- How to adjust the first month based on the effective rental days. I produced the % of MRR but I can't make this month unique so that the rental gets normal after the first month. I got the MRR adjusted but it expands all over the period.