Find Value in Same Table

Hello KayceVC 

Give this a try.  I had a check for the time on the 42 being after the time on the row but it doesn't read like you need that but I left it in the code and just commented it out.

Result = 
VAR TheDate = DATEVALUE ( auditdata[Date_Updated] )
VAR TheDateTime = auditdata[Date_Updated]
VAR TheUser = auditdata[User]
VAR NumRows = 0
RETURN
    IF (
        auditdata[Key_ID] = 22,
        CALCULATE (
            MAX ( auditdata[Date_Updated] ),
            FILTER (
                auditdata,
                auditdata[User] = TheUser
                && auditdata[Key_ID] = 41
                && DATEVALUE ( auditdata[Date_Updated] ) = TheDate
                --&& auditdata[Date_Updated] > TheDateTime
            )
        )
    )