3 Replies Latest reply on Jul 28, 2016 3:56 PM by Jonathan Oakleigh

    Lookup one column, return value from another column

    Jonathan Oakleigh

      Hello again team Tableau!

       

      Hoping to pick your collective brains...

       

      I have a dataset that looks like this:

       

      Created_atLatitude
      1/1/2016153
      2/1/201626
      3/1/20163
      4/1/20168

       

      I need a calculated field that looks up the most recent date, and returns the latitude for the date. So in the above field the value returned would be 8.

       

      I have been experiminenting with something like:

       

      LOOKUP(MAX([Created At]), FIRST() +1

       

      But that doesn't seem to do the trick.

       

      Any help greatly appreciated!

       

      -Jono