Show second last date value in card

[Fengol]

I have a table that shows the service history of a number of trucks within a fleet.

I then have a card that shows the date of next service (the latest date in the table), and I would also like a card that shows the date of previous service (the second latest date in the table). However, I cannot find a way to do this latter part.

I tried the following but it doesn't seem to work:

Measure = CALCULATE(MAX(table[ServiceDate] ),table[ServiceDate]   <> MAX(table[ServiceDate] ))

[v-jiascu-msft · Accepted solution]

Hi @Fengol,

Didn't it work? Or did it return the wrong result? Please try the formula below.  

Measure =
CALCULATE (
    MAX ( table[ServiceDate] ),
    FILTER (
        ALL ( table[ServiceDate] ),
        table[ServiceDate] <> MAX ( table[ServiceDate] )
    )
)

If it doesn't work, please provide a dummy sample file.

Best Regards,
Dale