Urgent Unable to create amortization table in Power BI

[Rahulsingh]

Hi Everyone, 

I am trying to create an amortization table in power bi from a database.

In the database, I have mortgage balance, Account and Term Interest Rate. Currently, loan database only has the payments made in prior months. The user is unable to see entire Loan amortization table. 

I have created a date Dimension but I don't know how to generate an entire amortization table.

If I can get help in generating a table with future dates until MtgBalance becomes zero that would be a great help. 

Thank you in advance.