Add and subtract from Running total

All good now thank you again.

Zidane22 

This is exactly what my proosed dax is doing. To eliminate the problem of the first row please try

Calculation =
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] )
),
IF (
'All Web Site Data (2)'[Date] <> BLANK (),
'All Web Site Data (2)'[Column1] - 'All Web Site Data (2)'[Column2]
)
)
RETURN
InService - Result

Zidane22 

Adjust the "3" to obtain the correct value 

So it seems its calculating the same way your first forumla provided. It's not starting from the first value, which is currently 90, it's started from -4  : ( 

Zidane22 

Can you share a screenshot showing the column that contains the starting value?

tamerj1 

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 

tamerj1  Please see last column, starting at 90 as an example.. (trucks left) the reults in the yelow column is what I'm looking for . for the one your talking about is the last column (TRUCKS LEFT) 

Zidane22 

Why have you ignored the first 3 rows of [Trucks Available] column (6, 14 & 4)?

tamerj1  , Sorry I i should have a starting time that everthing is defulted to zero to get the correct calculations. 

Lets start at 0300 ( no truck sign outs happens then)

Please see example how to calculate from the value 90 : 

tamerj1 , this works, but I belive the caluclations crew up because of the times from 0000-0200. Anyway to start this from the Time 0300 ? I belive this would slove this issue.

Thank you so much again 

Hello tamerj1 !

Sorry to bother you again, 

If I were to use the value in the second row or thrid row etcc.. how can i modify ths part : 

VAR InService = MAXX ( T, 'All Web Site Data (2)'[EBS IN SERVICE] ) VAR Result = SUMX (

Thanks again!  

tamerj1 , seems to be calculating correcly but the value is starting at Zero instead of the actual value, like the one we had before, (90) . Thanks again 

tamerj1 , sorry for the stupid question , I Did put three and still shows Zero,  where do i put the three exactly?