Calculated fields

Looker Studio calculated field – Older date from a date field

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

Most recent date

  • Explanations of the formula step by step
    1. Get the older date of the date field using MIN function that returns a numeric output
    2. Parse the numeric to cast it as a date using PARSE_DATE function
  • Input
    • Any date type dimension
  • Output
    • The older date
  • Used functions