Forum Discussion

lizzy's avatar
lizzy
Helper I
6 years ago
Solved

Most recent previous date

HI I have a table that looks something like this Person ID Date A 12/31/2019 A 12/1/2019 A 10/2/2019 A 6/1/2019 B 12/10/2019 B 10/1/2019 C 6/12/2019 C 3/1/2019 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago
    Previous date =
    var date_ = 'Table'[Date]
    var ID_ = 'Table'[Person ID]
    return
    CALCULATE(MAX('Table'[Date]);FILTER(ALL ('Table') ; 'Table'[Person ID] = ID_ && 'Table'[Date] < date_))