Occupany, Culmulative total help

Yeah basically, i just want the accumulated column to count but not go below zero :),

Thanks :),
Molly

Hi molzmad ,

Is the following result what you want? (column 2)

Best Regards,

Yuna

Hi 🙂 column two looks right but i just want it to count accumulatively i.e. column 2 would look like this :

Hi molzmad ,

Based on your description, you can create two calculated columns as follows.

Rank =
RANKX ( ALL ( 'Enliteon_Office_Test Count_Events' ), [timestamp],, ASC )

Test_value =
VAR x1 =
    MAXX (
        FILTER (
            ALL ( 'Enliteon_Office_Test Count_Events' ),
            [Rank] <= EARLIER ( 'Enliteon_Office_Test Count_Events'[Rank] )
                && [Ins_Outs] < 0
        ),
        [Rank]
    )
RETURN
    [Rank] - x1

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi almost, i just want the -1 to minus from the prior number i.e. 3,2,1 rather than the -1 equal zero if that makes sense, but just not allow the column to go below zero, like an accumulative sum that cant go below zero