Ranking based on Datetime reseting per each Key

Hi vojtechsima ,

Create a column as below:

_Ranking =
VAR _previousField =
    CALCULATETABLE (
        VALUES ( 'Table'[History Field] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Index] < EARLIER ( 'Table'[Index] ) )
    )
VAR _index =
    CALCULATE (
        MAX ( 'Table'[Index] ),
        FILTER (
            'Table',
            'Table'[History New Value] = "new"
                && 'Table'[Index] < EARLIER ( 'Table'[Index] )
        )
    )
VAR _count2 =
    CALCULATE (
        COUNT ( 'Table'[History Field] ),
        FILTER (
            'Table',
            'Table'[Index] >= _index
                && 'Table'[Index] <= EARLIER ( 'Table'[Index] )
                && 'Table'[History Field] = "status"
        )
    )
RETURN
    IF (
        NOT ( "status" IN _previousField ),
        IF ( 'Table'[History Field] <> "status", 0, 1 ),
        IF ( 'Table'[History New Value] = "new", 1, _count2 )
    )

And you will see:

Pls note that the line 7 should be 1,as it has a new key.

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!