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...
Did you ever find the answer as to why the dim_loan[payment_months] field (or anything else for that matter) was causing the issue? I have just encountered this myslef and am tearing my hair out... and I have none!
