Forum Discussion
Helper IHelp calculating Loans, Interests and Principals
Helper IHi Walk, thanks for the reply.
For this purpose, I'm just assuming interest is daily (regardelss of weekends/public holidays/ etc..)
In Excel it would be easy to accomplish. I need to accomplish it in Power BI somehow.
I already have a date table in the model.
My struggle is with the logic. I have one line for the loan, and then in the other table multiple lines for the payments against a loan.
However I cannot think of a way to manage the daily accrued interest on the loan so that I can quickly see at any point in time, how much has been accrued. Seeing how much has been paid off is easy - I just look at the Payment table.
Would creating another table called "Interest Accrued" work. And if so, what would the logic behind the table be?
Helper VAh ok. I think you would probably want a table to contain your key loan information, and then another table where for every day (and for every loan), you would calculate the remaining principal, by calculating the amount of interest incurred and payment received, and adding/subtracting that. I guess you know how to do the calc. Idenally you would have the interest rate loaded as a parameter. So eventually for each loan you would have multiple rows, one of each day, with the loan reference and the balance. This table would then have amany to one relationship with your loan reference table.