Forum Discussion

Dee's avatar
Dee
Icon for Helper III rankHelper III
6 years ago

How to find second latest date after max date

Hi all, I am trying to find the second latest date after the MAX date. orderdate 2019-12-11 2019-12-31 2019-12-31 This is what I have tried but doesn't seem to work. ``` calcul...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dee - You can do a measure like the following:

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