Forum Discussion

shephee's avatar
shephee
Frequent Visitor
3 years ago

PMT function in DAX

I am trying to utilize the PMT function in DAX with this formula:  Monthy Payment = pmt(dim_loan[loan_interest_rate]/12,dim_loan[payment_months],dim_loan[loan_original_amount])   When I run it I...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

shephee Do you have a blank somewhere in your data?

shephee's avatar
shephee
Frequent Visitor
3 years ago

There are no blanks values.  I checked and I see some 0's but I filtered those out and still have the issue.

  • v-yinliw-msft's avatar
    v-yinliw-msft
    Community Support
    3 years ago

    Hi shephee ,

     

    You should Make sure that you are consistent about the units you use for specifying rate and nper.

    Rate is the first parameter and nper is the second parameter about the PMT function.

    If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 0.12/12 for rate and 4*12 for nper.

    If you make annual payments on the same loan, use 0.12 for rate and 4 for nper.

     

    For more information, you can refer this documentation:

    PMT function (DAX) - DAX | Microsoft Learn

     

    Hope this helps you.

     

    Best Regards,

    Community Support Team _Yinliw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.