how to have the product of a previous row stored in the following row

[Anonymous]

How do I create a calculated column that accomplishes the same transformations as the transformation shown in the Excel Example?

Excel Example

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Is there only one value in column K currently? You can try this column expression

Column = 
var _firstK=MAXX(FILTER(ALL('Table'),'Table'[K]<>BLANK()),'Table'[K])
var _sumH=SUMX(FILTER(ALL('Table'),'Table'[Index]<=EARLIER('Table'[Index])),'Table'[H])
var _sumI=SUMX(FILTER(ALL('Table'),'Table'[Index]<=EARLIER('Table'[Index])),'Table'[I])
var _sum=_firstK-_sumH+_sumI
return _sum

result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.