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.

Most recent date

PARSE_DATE("%Y%m%d",MAX(Date))

• Explanations of the formula step by step
  1. Get the max Date of the date field using MAX function that returns a numeric output
  2. Parse the numeric to cast it as a date field using PARSE_DATE function

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