Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Urgent Unable to create amortization table in Power BI

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.

Power BI question.JPG

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.  



Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors