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