Second Date

[cnestg8r]

Given a filtered column example of production dates:

It is clear how to get the first and last date, but I need the second production date. Note that any date could have multiple repeats. I have gotten it in DAX Studio using LASTDATE and TOPN, but I am stuck creating it as a calculated column.

 

[cnestg8r]

This is from DAX Studio...

LASTDATE(TOPN(2,VALUES(Table1[OrderDate]),Table1[OrderDate],1)))

 

[cnestg8r]

Too easy. The second date is the first date greater than the real first date.