SwitchIf(
Not(IsBlank(thisRow.Plazo)),
WithName(
thisTable
.Filter(
Tarea = thisRow.Tarea And Instancia = 1
)
.First()
.Plazo,
plazoOriginal,
WithName(
SwitchIf(
thisRow.Veces <= 1,
0,
thisRow.Veces.isBlank(),
-1,
thisRow.Veces - 1
),
repeticiones,
SwitchIf(
thisRow.[Se repite cada] = "Semana" And repeticiones != -1,
plazoOriginal + 7 * repeticiones,
thisRow.[Se repite cada] = "Mes" And repeticiones != -1,
RelativeDate(plazoOriginal, repeticiones),
thisRow.[Se repite cada] = "Año" And repeticiones != -1,
Date(
plazoOriginal.Year() + repeticiones,
plazoOriginal.Month(),
plazoOriginal.Day()
)
)
)
)
)