I have a spreadsheet of loans, where each loan is one row. I have columns for "Original Loan Amount", "Payment Amount $", "Payment Frequency", and "Rate %", and I'd like to use the nper function to find the term of the loan. Currently I do this in excel using the nper() function, but I would like to do this in power query. Is there a straightforward way to do this? I am a novice user, and am going to create a custom column and would need to know exactly what to type in the Custom Column Formula box.
in excel I would do =NPER(Rate/PayFreq, Payment, -original loan amount).
Thank you
in excel I would do =NPER(Rate/PayFreq, Payment, -original loan amount).
Thank you
