Find changes made in set of data

Hi,

It is easily to reach it.

Please try to create this calculated column first:

Group = RANKX('Table','Table'[Reportdate],,ASC,Dense)

Then try this measure:

Measure = 
VAR check =
    IF (
        MAX ( 'Table'[Reportdate] ) = MINX ( ALL ( 'Table' ), 'Table'[Reportdate] ),
        BLANK (),
        CALCULATE (
            MAX ( 'Table'[Status] ),
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Group]
                    = MAX ( 'Table'[Group] ) - 1
                    && 'Table'[Object] = SELECTEDVALUE ( 'Table'[Object] )
            )
        )
    )
RETURN
    IF ( MAX ( 'Table'[Status] ) <> check && check <> BLANK (), 1, BLANK () )

Apply this measure to the original table visual, the result shows:

Here is my changed pbix file:

pbix 

Hope this helps.

Best Regards,

Giotto Zhi