How to find second latest date after max date

Hi Dee ,

Please create a measure as below.

Measure = 
VAR maxdate =
    CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) )
RETURN
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Date] < maxdate )
    )

For more details, please check the pbix as attached.

Dee - You can do a measure like the following:

Second Largest = 
var _Largest = max(Orders[orderdate])
return CALCULATE(
    max(Orders[orderdate]),
    Orders[orderdate] < _Largest
)

try putting all

calculate(max(orders[orderdate]),
filter(all(orders), orders[orderdate]<> max(orders[orderdate])))
or
calculate(max(orders[orderdate]),all(orders[orderdate]),
filter(orders, orders[orderdate]<> max(orders[orderdate])))

Have this been solved?

Am I right in thinking that you are looking for the previous date to the max date?

 I had a similar issue and someone gave me the following formula. This will look for the previous date before your MAX date. If there is no date then the MAX date will be given.

Previous = 

VAR MaxDate = CALCULATE(MAX('Table1'[Date]), ALL('Table1'[Date]))

VAR PreviousDate = CALCULATE(MAX('Table1'[Date]), 'Table1'[Date] < MaxDate)

return IF(ISBLANK(PreviousDate), MaxDate, PreviousDate)

Do you know how to get the days difference between the last date and the second last date of a specific customer? Please can anyone assist?