Forum Discussion

EddyW's avatar
EddyW
Frequent Visitor
3 years ago
Solved

Goal Seek to Each Row for Effective Interest Rate

Hello Everyone,   Before I explain what my problem is, please read my case first:   Company A have to loan using 2 source of fund, which backed up by loan and capital, respectively 70% and 30%. T...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi EddyW ,
    if you want a fast calculation, I strongly recommend to use DAX in this case. Using the RATE function after using the PMT-function does the trick. See enclosed file. 150k rows load in a couple of seconds.

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
3 years ago

Hi EddyW ,
if it is strongly related to your original question or you have a question to my answer, then doing it here is fine.

Otherwise just open a new thread and ImkeF  me in there so that it pops up in my notifications.