Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Did anyone manage to solve this? I'm taking a look at this as well.
@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
Can someone help?
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
98 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |