4 Replies Latest reply on Jul 12, 2018 7:31 AM by Tram Le-Nguyen

    Calculate the nearest date

    Tram Le-Nguyen

      Hi,

       

      I am trying to calculate the closest date. I found this: Calculated field to find closest date but I'm having a hard time applying the same calculation to my workbook.

      I currently have two blended data sources (I am not able to join). One date is the Failure Date and I am trying to find the nearest Test Date before the failure date. Both data sources is linked by a Title field. May I have some guidance?

       

      I'm currently using Tableau Desktop 2018.1

       

      Thank you in advance!