KNOWLEDGE BASE

Calculating Most Recent Date in the Data Set


Published: 22 Aug 2016
Last Modified Date: 23 Sep 2019

Question

How to find the most recent date in the data set.

Environment

Tableau Desktop

Answer

Create a calculated field with a name like "Most Recent Date" with a calculation similar to the following:
{ FIXED : MAX( [Date] ) }

Additional Information

When no dimensions are added to an LOD expression, Tableau Desktop calculates the aggregation for the entire data set.



Discuss this article... Feedback Forum
Did this article resolve the issue?