topic Dynamic monthly payment for Amortization Schedule Dax Hep Urgent in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-monthly-payment-for-Amortization-Schedule-Dax-Hep-Urgent/m-p/2042706#M45869 <P>I have created a ticket&nbsp;<A href="https://community.powerbi.com/t5/Desktop/Amortization-Cumulative-Schedule-DAX-and-Power-BI-Help/m-p/1528537#U1528537" target="_blank" rel="noopener">Amortization Cumulative Schedule DAX and Power BI Help</A>&nbsp;which got resolved by<SPAN>&nbsp;</SPAN><A href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/259995" target="_blank" rel="noopener">@v-janeyg-msft</A>&nbsp;,&nbsp;&nbsp;<SPAN>but it's facing an issue when rental payment changes every year for any lease. As per the screenshot below, whenever the</SPAN><U><STRONG><SPAN>&nbsp;</SPAN>rental payment changes</STRONG></U><SPAN>&nbsp;</SPAN><SPAN>it</SPAN><FONT color="#FF0000"><U><SPAN>&nbsp;</SPAN><STRONG>doesn't take</STRONG></U></FONT><SPAN>&nbsp;</SPAN><SPAN>the</SPAN><SPAN>&nbsp;</SPAN><FONT color="#FF9900"><U><EM><STRONG>beginning balance</STRONG></EM></U></FONT><SPAN>&nbsp;</SPAN><SPAN>from</SPAN><SPAN>&nbsp;</SPAN><FONT color="#FF9900"><EM><STRONG><U>previousending balance</U>.&nbsp;</STRONG></EM></FONT><SPAN>I have attached the link of PBIX sample file based on your previous solution. please help?&nbsp;</SPAN><FONT color="#3366FF"><EM><A title="PBIX Sample File Link - One Drive" href="https://1drv.ms/u/s!AhQErDrpD6YwgQHgACa-lNOTxKlG?e=0lhQhF" target="_blank" rel="noopener nofollow noreferrer">PBIX Sample File Link - One Drive</A>&nbsp;</EM></FONT></P><P>&nbsp;</P><P><img /></P><P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="119281" data-lia-user-login="dax" class="lia-mention lia-mention-user">dax</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="258050" data-lia-user-login="MSFTPBI" class="lia-mention lia-mention-user">MSFTPBI</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="285397" data-lia-user-login="v-syr" class="lia-mention lia-mention-user">v-syr</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="252271" data-lia-user-login="v-xul" class="lia-mention lia-mention-user">v-xul</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="275884" data-lia-user-login="v-henryk-mstf" class="lia-mention lia-mention-user">v-henryk-mstf</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="78297" data-lia-user-login="DAXhelpAcc" class="lia-mention lia-mention-user">DAXhelpAcc</a>&nbsp;</P><P>&nbsp;</P> Fri, 27 Aug 2021 10:41:18 GMT farooqk_aziz 2021-08-27T10:41:18Z Dynamic monthly payment for Amortization Schedule Dax Hep Urgent https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-monthly-payment-for-Amortization-Schedule-Dax-Hep-Urgent/m-p/2042706#M45869 <P>I have created a ticket&nbsp;<A href="https://community.powerbi.com/t5/Desktop/Amortization-Cumulative-Schedule-DAX-and-Power-BI-Help/m-p/1528537#U1528537" target="_blank" rel="noopener">Amortization Cumulative Schedule DAX and Power BI Help</A>&nbsp;which got resolved by<SPAN>&nbsp;</SPAN><A href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/259995" target="_blank" rel="noopener">@v-janeyg-msft</A>&nbsp;,&nbsp;&nbsp;<SPAN>but it's facing an issue when rental payment changes every year for any lease. As per the screenshot below, whenever the</SPAN><U><STRONG><SPAN>&nbsp;</SPAN>rental payment changes</STRONG></U><SPAN>&nbsp;</SPAN><SPAN>it</SPAN><FONT color="#FF0000"><U><SPAN>&nbsp;</SPAN><STRONG>doesn't take</STRONG></U></FONT><SPAN>&nbsp;</SPAN><SPAN>the</SPAN><SPAN>&nbsp;</SPAN><FONT color="#FF9900"><U><EM><STRONG>beginning balance</STRONG></EM></U></FONT><SPAN>&nbsp;</SPAN><SPAN>from</SPAN><SPAN>&nbsp;</SPAN><FONT color="#FF9900"><EM><STRONG><U>previousending balance</U>.&nbsp;</STRONG></EM></FONT><SPAN>I have attached the link of PBIX sample file based on your previous solution. please help?&nbsp;</SPAN><FONT color="#3366FF"><EM><A title="PBIX Sample File Link - One Drive" href="https://1drv.ms/u/s!AhQErDrpD6YwgQHgACa-lNOTxKlG?e=0lhQhF" target="_blank" rel="noopener nofollow noreferrer">PBIX Sample File Link - One Drive</A>&nbsp;</EM></FONT></P><P>&nbsp;</P><P><img /></P><P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="119281" data-lia-user-login="dax" class="lia-mention lia-mention-user">dax</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="258050" data-lia-user-login="MSFTPBI" class="lia-mention lia-mention-user">MSFTPBI</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="285397" data-lia-user-login="v-syr" class="lia-mention lia-mention-user">v-syr</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="252271" data-lia-user-login="v-xul" class="lia-mention lia-mention-user">v-xul</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="275884" data-lia-user-login="v-henryk-mstf" class="lia-mention lia-mention-user">v-henryk-mstf</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="78297" data-lia-user-login="DAXhelpAcc" class="lia-mention lia-mention-user">DAXhelpAcc</a>&nbsp;</P><P>&nbsp;</P> Fri, 27 Aug 2021 10:41:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-monthly-payment-for-Amortization-Schedule-Dax-Hep-Urgent/m-p/2042706#M45869 farooqk_aziz 2021-08-27T10:41:18Z Re: Dynamic monthly payment for Amortization Schedule Dax Hep Urgent https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-monthly-payment-for-Amortization-Schedule-Dax-Hep-Urgent/m-p/2044986#M45935 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="273752" data-lia-user-login="farooqk_aziz" class="lia-mention lia-mention-user">farooqk_aziz</a> , Tried similar stuff here. Please check. </P> <P>&nbsp;</P> <P><A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Financial-Magic-to-continue-with-10-Recently-added-Function/td-p/1233163" target="_blank">https://community.powerbi.com/t5/Quick-Measures-Gallery/Financial-Magic-to-continue-with-10-Recently-added-Function/td-p/1233163</A></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>if needed check</P> <P><A href="https://www.youtube.com/watch?v=6oaSdjZ_FLQ" target="_blank">https://www.youtube.com/watch?v=6oaSdjZ_FLQ</A></P> <P><A href="https://www.youtube.com/watch?v=9VYqbj2h4zE" target="_blank">https://www.youtube.com/watch?v=9VYqbj2h4zE</A></P> Mon, 30 Aug 2021 03:45:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-monthly-payment-for-Amortization-Schedule-Dax-Hep-Urgent/m-p/2044986#M45935 amitchandak 2021-08-30T03:45:49Z