Dear Community,
I am somewhat familiar with the concepts of data modeling and data manipulation, but not so confident in using DAX. I want to improve my skills and create an repayment/amortization schedule for n bank loan, using DAX instead of Excel this time. I'm here to ask more experienced community members for tips and tricks on how to tackle this, or for pointers on where I can find solid learning material that will enable me to do this (maybe any recommendations).
Starting situation:
10 bank loans, ongoing repayment schedule until Dec23, variable and fixed interest rates (different for each loan), different currencies, different repayment intervals (monthly, quarterly, semi-annually, annually and the intervals can also differ from the calendar year), start and maturity dates.
Target:
Create repayment schedule/forecast by 12/27, scenarios for interest rates (i.e. one can adjust interest rates (manually in dashboard if possible) based on different scenarios) on monthly basis, calculate start of period/end of period, calculate monthly repayment rate (also for those with quarterly/semi-annual/annual basis), total for respective intervals/accruals, calculate monthly interest, calculate cash effect, convert currencies
Now my questions:
Should the flat file already contain all the information up to Dec27, or can I plan it all with DAX using Dec23 as a starting point?
Is there a structured approach/concept for this?
Do you guys have a recommendation on what formulas/packages I should use, or a recommendation on where I can get insight/knowledge/learning material to delve in?
Thank you in advance and have a nice day!
