For each loop in expression

[a34]

I have a dataset which has name, date and values.

I want the result as attached in the sample data excel. 

The formula for result is for the first time it's 1*(value1+1) - for 2nd iteration it's --> result * (value2 +1) - for 3rd iteration it's --> result * (value3 + 1) and so on.

Thanks

[Saravanan_Desingh · Accepted solution]

Try this,

tab1:
LOAD *, Alt(Peek(Result),1)*(Values+1) As Result;
LOAD Name, 
     Date, 
     Values 
FROM
[D:\HereDownloads\Sample data (2).xlsx]
(ooxml, embedded labels, table is Sheet1);

[a34]

Thanks Saravanan, works like charm.