6 Replies Latest reply on May 10, 2018 2:35 PM by Gerardo Varela

    Calculated Field for Closest Date before Today()

    Beatrix Balogh

      Hi all, I'm struggling with how to create a calculated field so that I can filter on the single date in my 'Due Date' dimension that is closest to being before Today().


      Attached a sample packaged workbook.


      I did figure out how to create the calculated field for only showing due dates that have happened (e.g. filtering out all future due dates), but for some reason the next step of honing in on the max of that isn't working for me. I created 'Max Due Date Passed', which literally just takes the max of the due dates that have passed, but it doesn't give me the single most recent date.


      Thank you in advance!