Dax Measure to Specify which rows correspond to last change

[lazurens2]

Hello, 

I have this example please 

Expected output : a Measure that returns 1 for a = 3 / b = 6
These are verions and I need to specify which one is the last version

I tried this, the measure isn't even working because it couldn't find `_LastChange`

Best Score 2 = 
VAR _LastChange = SUMMARIZECOLUMNS('Table'[Column1],
"Maxd", Max('Table'[Column2])
)
VAR _group = VALUES('Table'[Column1])
VAR _max = _LastChange[Maxd]

Return 

VAR MaxValue =
    CALCULATE ( MAX ( 'Table'[Column2] ), REMOVEFILTERS ( 'Table' ) )
RETURN
    IF ( SELECTEDVALUE ( 'Table'[Column1] ) = _group, 
        IF(Filter('Table', 'Table'[Column1] = _group) = _max , 1, 0 )
)

Thank you in advance

[tamerj1 · Accepted solution]

Hi @lazurens2 

do you want to flag the last record of each value of column1? If so please try

Best Score 2 =
VAR CurrentValue =
    SELECTEDVALUE ( 'Table'[Column2] )
VAR MaxValue =
    CALCULATE ( MAX ( 'Table'[Column2] ), ALLEXCEPT ( 'Table', 'Table'[Column1] ) )
RETURN
    IF ( CurrentValue = MaxValue, 1 )

[lazurens2]

Thank you very much, it's working !