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
- Get the max Date of the date field using MAX function that returns a numeric output
- 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