I have this report, but I am not able to create scorecard or table with with latest date value. Before it was working in Scorecard with MAX(date) query, but I got info that "Scorecard not working this way anymore after last update", but seems that also in table not working. When you check the screenshots there is showing only type (Text) and not date type as expected. Any idea how to fix this please ?
FYI: now is showing in report last update from May 28, even there is also data May 29, but it sorted now according SUM(Confirmed) Values , unable to sort by date
Here is my report and some screenshots
https://datastudio.google.com/reporting/6e242aa8-9cda-47c4-8ef5-e52a7148d9bd
Adapted from an Earlier Answer, using an Editable Copy of the Google Data Studio Report above and a GIF to elaborate (feel free to have a look through and copy and paste the Table created below, in your report):
1) Data Tab
date
date
in Descending order 2) Style Tab
3) Text Box & Grouping