AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
2.9K members online now
2.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Get the most recent date

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi everyone, I was hoping someone could help. Basically what I want is to show the value of a metric off the most recent date in the dataset. I tried MAX(Date) but unfortunately it did not work. 

 

This was my formula: SELECT Value1 WHERE Date  = MAX(Date)

 

Any help will be appreciated!

 

Thanks in advance

Get the most recent date

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I've been looking to do something similar but haven't found a way in GDS. My backup plan is a second sheet in Spreadsheets where I use ifs and vlookups to filter my data the way I want.

Get the most recent date

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I tried to do something similar to show the latest date of import. My quick solution was to add a simple table to return max date diff: MAX(DATE_DIFF(Day, Day)), giving me a table of two rows, earliest and latest date. Further I changed colours to transparent or white and minimised the entire table to only show the latest date.

 

You can do the same and the metrics you want.