Forum Discussion
Calculate and filter
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
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
2 Replies
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 Yuthank you for your solution .
but I want instead of the SUM I do the product .
Thanx ;)
