waterfall chart logic

Hello, I am not quite sure how to phrase my question so I apologize in advance, I have a data-set which is fairly standard. We are evaluating the rental rate for each given period based on a DAX patt...