3 Replies Latest reply on Aug 8, 2016 9:09 AM by swaroop.gantela

    Return nearest value

    Jonathan Oakleigh

      Hello,

       

      I have a dataset that looks something like this:

       

      Values in table 1Values in table 2Closest Value
      153.43153.2153.44
      543.55153.44
      33.45154.6
      53.26154.7

       

      What I need to do is have Tableau look at the value in Table 1, then scan the Table 2 column to identify the closest value, and then return that value.

       

      To quote many who have gone before me "I feel like this is something Tableau should be able to do..." haha.

       

      Any help would be greatly appreciated!

       

      Thanks