Calculate and filter

[anassel]

hi team 

please help me t reslove this problem 

I want to generate a new column in each line there is the product of cellulles selected in green

 

[v-qiuyu-msft · Accepted solution]

Hi @anassel,

You can create a index column: 

index = CALCULATE(COUNT(Table1[Column1]),FILTER('Table1','Table1'[Column1]<=EARLIER(Table1[Column1])))

Then create a calculated column below: 

Column = CALCULATE(SUM(Table1[Column1]),FILTER('Table1','Table1'[index]>EARLIER(Table1[index])))
+ CALCULATE(SUM(Table1[Column2]),FILTER('Table1','Table1'[index]<EARLIER(Table1[index])))
+ Table1[Column3]

Best Regards,
Qiuyun Yu 

[anassel]

thank you for your solution .

but I want instead of the SUM I do the product . 

Thanx 😉