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


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




      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.