Forum Discussion
Power Query creating a custom function automate
Dear all, Currently I am trying to automate loan schedule in power query the following are the key points: Opening Balance is Rs.150,000 Monthly deduction is fixed per month Rs.4500 Interest ...
I'm not at all sure why you're linking this all to Power Query. The kind of results you describe appear to be available solely through using a few of the many Financial Functions in "normal" Excel. You can find them all on this page from a helpful and instructive website.
Here to illustrate is a partial list: