1 Reply Latest reply on Feb 5, 2016 6:47 AM by pooja.gandhi

    Trying to Find MAX Date, but returns 2 records when there is a corresponding status

    Varun Akula

      I have been trying to get records with MAX Date but all the time, Tableau keeps returning 2 records when I add a status column. If I dont have the status column added, it does return only the MAX date. Seems to be like a very simple issue, but was not able to get it worked.

       

      Here's how my data is:

        

      Date       Status
      1/10/201632
      1/9/201616
      2/1/201616
      2/2/201616

       

      When I apply the calculation MAX(Date), it returns back with 2 rows:

        

      DateStatus
      1/10/201632
      2/2/201616

       

      My end result should retrieve only the row with 2/2/2016 as it is the MAX date and the corresponding Status.

      But, when I remove the status column it does retrieve only 2/2/2016.