Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create a column which calls itself

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's avatar
    Anonymous
    7 years ago

    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])

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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])