Looker Studio calculated field – Most recent date from a date field

The Looker Studio (ex Google Data Studio) calculated field below returns the most recent date from a date dimension. The max date in other words.

• Explanations of the formula
  • Get the most recent Date of the date field using MAX function
  • Use LEFT_TEXT to extract the date part of the date time
  • Parse the text to cast it as a date using PARSE_DATE function when it is a unaggregated dimension
  • If you need a standalone field, without blending, it is easier to create a calculated field as an aggregated metric, using only MAX function (second formula below)

• Input
  • Any date type dimension
• Output
  • The most recent date
• Used functions
  • MAX
  • LEFT_TEXT
  • PARSE_DATE

Most recent date as dimension

PARSE_DATE("%Y/%m/%d",LEFT_TEXT(MAX(Date),10))

Most recent date as an aggregated metric 

MAX(Date)