Create a column which calls itself

[Anonymous]

Hello

I want to calcultate the stock of the number of tickets treated each month. I go from the actual nulmber of remaining tickets to know the ones that were treated.

In excel for example, (see the table) to obtain 21 in the last column, i have to do 20 (from next row) + 10 +25-34.

So the last column calls the next index

Is it possible with power BI?

The last value for the last column in the table is the total remaining number of tickets.

s

Thanks

[Anonymous · Accepted solution]

After trying to analyse this is the formula that helped me:

'Table'[Total]+SUMX(FILTER('Table';'Table'[Month]>=EARLIER('Table'[Month]));'Table'[Closed])-SUMX(FILTER('Table';'Table'[Month]>=EARLIER('Table'[Month]));'Table'[Open])