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