3 Replies Latest reply on Jul 11, 2018 1:43 PM by Michel Caissie

    Display previous date based on another date dimension

    Ty Adams

      Hope this is an easy one. I have a data set that I am trying to display the first date that meets certain criteria based on the date from another dimension. My data is confidential but I have attached a workbook with a sample date set.

       

      What I am looking for - Display the closest Install Date that is before the Departure Date for each ship.

       

      what I would like to see- based on following criteria. Install date must be before Departure date. Display only one install date that is closest to the departure date.

       

      Correct results are highlighted.

      Seems simple, but I am having issues any help would be greatly appreciated