Accumulating using previous

[Casperserven1]

I am trying to do tthe following and struggling - I am sure this is easy but just can't see it.

New Hires	Retirees	Total Workforce
3	5	20
6	3	23
8	1	30
9	8	31
4	6	29
3	1	31
2	1	32
7	8	31

So in excel my first row = 22 +New Hires - Retirees

My second row = 20 (the result from the previous row) +NewHires - Retirees
My third row    = 23  (the result from the previous row) +NewHires - Retirees
etc.. 
Tried various things including EARLIER, using indexing, 

[tamerj1]

Hi @Casperserven1 
Is this a data table or a table visual? How did you get the first value (22)?

[Casperserven1]

and this is the raw data.

[tamerj1]

@Casperserven1 
Please refer to attached sample file with the proposed solution

Total Workforce = 
VAR StartingWF = 22
VAR TableOnAndBefore = 
    FILTER ( 'Table', 'Table'[Date] <= EARLIER ( 'Table'[Date] ) )
VAR Change = 
    SUMX ( TableOnAndBefore, 'Table'[New Hires] - 'Table'[Retirees] )
RETURN
    StartingWF + Change

[Casperserven1]

Thanks the pbix worked perfectly, however when I tried the technique with other data this is what occurred...any ideas??

[tamerj1]

@Casperserven1 
It should be a calculated column not a measure!

[Casperserven1]

Thankyou so much , unfortunately it still isn't right. We only want the starting figure of 22 in the first row. after that is thould be adding and subtracting from the previous row.

[tamerj1]

@Casperserven1 
Please clarify further. Perhaps with a screenshot?

[Casperserven1]

yeah sure

[tamerj1 · Accepted solution]

@Casperserven1

Now I got it. Please try

Total Workforce =
VAR StartingWF = 22
VAR TableBefore =
FILTER ( 'Table', 'Table'[Date] < EARLIER ( 'Table'[Date] ) )
VAR Change =
SUMX ( TableBefore, 'Table'[New Hires] - 'Table'[Retirees] )
RETURN
StartingWF + Change

[Casperserven1]

The first value (22) is the starting workforce.