For a certain value, check its date and return its prior date

Question

I have a list of serial numbers and the date in which they were serviced.I also did a formula that is identifying the first repair and the duplicate repairs.But what I would need now is to know the date in which the prior repair came in&nbsp;Serial&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date Serviced&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Repeat?A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; First RepairB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; First RepairA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/05/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Duplicate RepairA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/07/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Duplicate Repair&nbsp;The expected outcome would be like this&nbsp;Serial&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date Serviced&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Repeat?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Prior Repair DateA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; First Repair&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; First Repair&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/05/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Duplicate Repair&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2019A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/07/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Duplicate Repair&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/05/2019&nbsp;Would appreicate your insights on this! I have already searched plenty but could not find something that fits the situation.Thank you!

alb · Accepted Answer

Hi&nbsp;Anonymous&nbsp;
Try this:
Prior Repair Date =
CALCULATE (
    MAX ( Table1[Date Serviced] ),
    Table1[Date Serviced] &lt; EARLIER ( Table1[Date Serviced] ),
    ALLEXCEPT ( Table1, Table1[Serial] )
)
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers&nbsp;&nbsp;
&nbsp;

Forum Discussion

For a certain value, check its date and return its prior date

2 Replies

Related content

Date Different return wrong value

Measure returning incorrect value

MAXX Returning duplicate values

Create Measure to Return Highest Value

Return Column Name if Zero Value