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:
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.