Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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
@dax @MSFTPBI @v-syr @v-xul @v-henryk-mstf @DAXhelpAcc
@farooqk_aziz , Tried similar stuff here. Please check.
if needed check
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 3 | |
| 2 | |
| 2 |