Peculiar multiplication with IF nested

[cdp_cre]

Hi, I want to ask how it's possibile to obtain a new calculated measure (called "TREND") that is obtained this way:

1) if the row for the month in "VALORE 2021" is not 0 then it's equal to "BUDGET PESATO"  * "DELTA % SUL MESE" both for the month where this condition is true

2) if the row for the month in "VALORE 2021" is 0 then the value is obtained for this month by multiplying "BUDGET PESATO" of this month and "DELTA % SUL MESE" value of the latest month when "DELTA % SUL MESE" was different from zero.

Thanks a lot.

[Anil_Babu_Samineni]

Perhaps this?

Sum(Aggr(If([VALORE 2021]<>0, "BUDGET PESATO"*"DELTA % SUL MESE",
If([VALORE 2021]=0, RangeSum(Sum({<MESE={$(=AddMonths(Max({<"DELTA % SUL MESE"={"=Sum("DELTA % SUL MESE")<>0"}>}MESE),-1))}>} "DELTA % SUL MESE"),Sum({<MESE={$(=Max(MESE))}>} "BUDGET PESATO"))), DIPARTIMENTO))

[cdp_cre]

Thanks a lot but I solved differently using nested above and if.