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.
Did this article resolve the issue?