Penultimate date of the column

[Anonymous]

Hello, I am trying to create a measure giving me the penultimate date of the column.
It seems simple, written like that, yet I'm breaking my teeth on it

 

thank guys

[Anonymous]

I made a mistake, I wanted the penultimate row in the column

[mahoneypat · Accepted solution]

This expression will get you the 2nd highest date in that column.

Penultimate Date = var maxdate = MAX(Table[Date_accident])

return CALCULATE(MAX(Table[Date_accident]), Table[Date_accident] < maxdate)

Regards,

Pat

[FredLEGUEN]

Very nice solution 👏👏👏

[S_JB]

This logic should work:

Penultimate Date = MAX(Table[Date_Accident])-1