Add and subtract from Running total

Zidane22 

Please try

RunningTotal =
VAR T =
ALL ( 'All Web Site Data (2)' )
VAR InService =
MAXX ( T, 'All Web Site Data (2)'[EBS IN SERVICE] )
VAR Result =
SUMX (
FILTER (
T,
'All Web Site Data (2)'[Date] <= MAX ( 'All Web Site Data (2)'[Date] )
),
'All Web Site Data (2)'[Column1] - 'All Web Site Data (2)'[Column2]
)
RETURN
InService + Result

Not sure.. it jumps to the 100's which dosen't make sense, should be counting down as they day goes on not counting up... 

Zidane22 
Noted. Please try

RunningTotal =
VAR T =
    ALL ( 'All Web Site Data (2)' )
VAR InService =
    MAXX ( T, 'All Web Site Data (2)'[EBS IN SERVICE] )
VAR Result =
    SUMX (
        FILTER (
            T,
            'All Web Site Data (2)'[Date] <= MAX ( 'All Web Site Data (2)'[Date] )
        ),
        'All Web Site Data (2)'[Column1] - 'All Web Site Data (2)'[Column2]
    )
RETURN
    InService - Result

Hello tamerj1 ,

it now going down but still jumping to 100 which dose not make sense when the max number is 90. I will play around with it . 

Can you please help me with the meausue for the first column please? Trucks being used?  Thank you again for all the help. 

Zidane22 

Do you mean without the 90? What is the issue with my first dax?

tamerj1 

So if you look at the table above, the first item is 90 (not sure why there is a zero) but the value 90 updates through powerautomate depending whats in service. So if we only have 90 trucks in service we go over this, it should go into the negtives and not to 100's. Like the number will always be beloew the 90 or what ever value is there . so starting number of this forumla should start at 90 then gose down as the day goes because we are actually using trucks, if it goes into the minus means we are short then by the end of the day the number should go back up with all the returns 

Zidane22 

Ok. Ignoring the first row which strangely has blank time, what should be the correct numbers? Please manually indicate in a screenshot