EARLIER function

HI kormosb,

You can try to use following calculate column formula, it can extract the last date and previous date to find out corresponding values:

last date value =
VAR prevDate =
    CALCULATE (
        MAX ( 'Issue Navigator'[Latest refresh date] ),
        FILTER (
            'Issue Navigator',
            [Key] = EARLIER ( 'Issue Navigator'[Key] )
                && DATEVALUE ( [Latest refresh date] )
                    < DATEVALUE ( EARLIER ( 'Issue Navigator'[Latest refresh date] ) )
        )
    )
RETURN
    IF (
        'Issue Navigator'[Latest refresh date] = BLANK ()
            || DATEVALUE ( 'Issue Navigator'[Latest refresh date] )
                = DATEVALUE ( MAX ( 'Issue Navigator'[Latest refresh date] ) ),
        CALCULATE (
            MAX ( 'Issue Navigator'[Solving day (original)] ),
            FILTER (
                'Issue Navigator',
                [Key] = EARLIER ( 'Issue Navigator'[Key] )
                    && [Latest refresh date] = prevDate
            )
        ),
       'Issue Navigator'[Solving day (original)]
    )

Regards,
Xiaoxin Sheng

HI kormosb,

You can extract the variable and use in a new calculated column to compare with current date:

Status =
VAR prevDate =
    CALCULATE (
        MAX ( 'Issue Navigator'[Latest refresh date] ),
        FILTER (
            'Issue Navigator',
            [Key] = EARLIER ( 'Issue Navigator'[Key] )
                && DATEVALUE ( [Latest refresh date] )
                    < DATEVALUE ( EARLIER ( 'Issue Navigator'[Latest refresh date] ) )
        )
    )
RETURN
    IF ( 'Issue Navigator'[Latest refresh date] >= prevDate, "Done" )

Regards,

Xiaoxin Sheng