Google Data Studio calculated field – Most recent date from a date field

The 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
Share