Forum Discussion
AdministratorIs it possible to generate a calculation loop?
Good morning, could you please help me with generating a calculated column which generates a calculation loop
The next expression is the one I need to generate as a loop
For i = 1 To VR
Period = Cant_Cuotas - VR+ i
Amortizacion_Capital = PPmt(Rate, Period, Cant_Cuotas, Capital) * -1
Next i
End Function
The data in my table
| CreditNumber | Cant_Cuota | rate | Capital | VR |
| 1111 | 12 | 120 | 10.000 | 11 |
| 2222 | 10 | 120 | 15.000 | 8 |
| 3333 | 15 | 122 | 25.0000 | 12 |
5 Replies
- lbendlin
Super User
This should be possible with PRODUCTX. What is your expected outcome?
Syndicate_AdminWhat I need is to calculate the "Present value" of some operations which I need to perform a loop calculation according to the number of quotas that the operation has, to be more specific I can attach the macro with which that calculation was made in excel.
Function Calculo_VA_FINMES(Cant_Cuotas, Capital, Vida_Remanente, Valor_Cuota, Tasa, Primer_Vencimiento, Fecha_Venta, tasa_P) As String
Amortizacion_Capital = 0
Cycle = Vida_Remanente
V_act = 0
days = 0
days = Primer_Vencimiento - Fecha_Venta
sum = 0
Tasa_P_cal = tasa_P / 100 * 1.21 / 365 * 30For i = 1 To Ciclo
Periodo = Cant_Cuotas - Vida_Remanente + iAmortizacion_Capital = PPmt(Tasa_P_cal, Period, Cant_Cuotas, Capital) * -1
Interes_S_IVA = (Valor_Cuota - Amortizacion_Capital) / 1.21
cuota_S_IVA = Amortizacion_Capital + Interes_S_IVA
V_act = cuota_S_IVA * (1 + (Tasa * 30 / 365)) ^ -(dias / 30)
The number = suma + V_act
Fecha_Vencimiento = WorksheetAction.EoMonth(Primer_Vencimiento, i)
What I need is to know how I could reconcile that looping calculation of the FOR expression since I have the rest of the data in columns
- lbendlin
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
- Syndicate_Admin
What I need is the loop that takes out the difference between VR and ODDS AMOUNT and adds up the quota amount taken from the difference obtained previously.
CreditNumber Cant_Cuota Capital VR 1111 12 10.000 11 2222 10 15.000 8 3333 15 25.0000 12 - lbendlin
I don't see an ODDS AMOUNT column.
