KNOWLEDGE BASE

Calculating Most Recent Date in the Data Set


Published: 22 Aug 2016
Last Modified Date: 07 Sep 2023

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.

See also Filtering with the Max Function.

 
Did this article resolve the issue?