Occupany, Culmulative total help

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