Tracking Changes under Unique ID

Hi graefs ,

 

I’ve made a test for your reference:

1\I assume there is a table(Table1)

 

2\Add a new column for Table1

TypeChange =

VAR CurrentType = 'Table1'[Type]

VAR PreviousType =

    CALCULATE(

        MAX('Table1'[Type]),

        FILTER(

            'Table1',

            'Table1'[Part] = EARLIER('Table1'[Part]) &&

            'Table1'[Date] < EARLIER('Table1'[Date])

        )

    )

RETURN IF(CurrentType <> PreviousType && NOT(ISBLANK(PreviousType)), 1, 0)

3\Create a new calculate table

NewTable = SUMMARIZE(Table1,Table1[Part],"Variance",SUM(Table1[TypeChange]))

 

 

Best Regards,

Bof