Forum Discussion

Jalil1985's avatar
Jalil1985
Copper Contributor
Jul 22, 2022

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 ...
office 365
Lorenzo's avatar
Lorenzo
Silver Contributor
Jul 23, 2022

Hi Jalil1985 

 

With a fixed monthly payment of 4500 and an annual rate of 8% I can't reconcile the numbers  (just a few) highlighted in red

 

 

On the other hand getting the following with PQ + a Pivot Table is no problem:

Resources