Imke Feldmann continues building functions:
Excel’s PMT function returns the payment for a loan based on constant payments and a constant interest rate. Using some clever math, it can be deducted via one formula (see rows 9-11):
As always, read on for the function contents and explanation. Imke also includes a video on applying custom functions to an existing Power BI solution.