5 Replies Latest reply on Jan 30, 2019 11:57 AM by an.dy

    LOD to perform vlookup by maximum of date

    an.dy

      Hi guys

       

      I have a data table In Tableau like this:

       

      Employee IDDATEPosition.......
      102019/01/01Intern
      102019/01/02Specialist
      202018/01/05Manager
      202019/01/01Director
      202019/01/02Director
      302018/01/01Specialist
      302019/01/02Specialist

       

      I need to add another column to the data in Tableau where I need to show in each of the rows the most recent position the employee has based on DATE column.

       

      The result should look like:

       

      Employee IDDATEPositionMost Recent Position....
      102019/01/01InternSpecialist
      102019/01/02SpecialistSpecialist
      202018/01/05ManagerDirector
      202019/01/01DirectorDirector
      202019/01/02DirectorDirector
      302018/01/01SpecialistSpecialist
      302019/01/02SpecialistSpecialist

       

       

      Can you help me with that?