Press "Enter" to skip to content

Payment Function in Power Query

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.