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.
Helpful resources
Happy New Year from Power BI
This is a must watch for a message from Power BI!
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
Mark your calendars and join us for our next Power BI Dev Camp!.
