Amortization Cumulative Schedule Dax

[farooqk_aziz]

I have created a ticket Amortization Cumulative Schedule DAX and Power BI Help which got resolved by @v-janeyg-msft ,  but it's facing an issue when rental payment changes every year for any lease. As per the screenshot below, whenever the rental payment changes it doesn't take the beginning balance from previousending balance. I have attached the link of PBIX sample file based on your previous solution. please help? PBIX Sample File Link - One Drive 

[Anonymous]

Did anyone manage to solve this? I'm taking a look at this as well. 

[amitchandak]

@farooqk_aziz ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

You can try closingbalancemonth, openingbalancemonth and first/last nonblankvalue

refer

https://www.youtube.com/watch?v=yPQ9UV37LOU&t=124s

https://www.youtube.com/watch?v=6lzYOXI5wfo

[farooqk_aziz]

Can someone help? 

[farooqk_aziz]

@amitchandak  here is the link for sample file 
https://1drv.ms/u/s!AhQErDrpD6YwgQHgACa-lNOTxKlG?e=0lhQhF. I have tried but it is not working in my requirment.