Cash Flow in a Virtual Colum

[augustor4]

Hi Guys,

I have the following table…

ID VALUE
1 100
2 -20
3 70

How can I add a VIRTUAL COLUM to do a CASH FLOW, like that

ID VALUE CASHFLOW
1 100 100
2 -20 80
3 70 150

SO, the CASHFLOW sums previous ids…

[Rodrigo_Dorador]

Based on the example you gave, you could use the sum and select formulas.

You can use something like SUM(SELECT(Table[VALUE], ([ID] <= [_THISROW].[ID])))

[coolasky]

initial value 

ANY(
SELECT(
table[column],
([_ROWNUMBER] = MAX(table[_ROWNUMBER]))
)
)

FORMULA

Column 3 + Column 2