'How to show the previous day and time date and specific hour in Data Studio?

I would like to know if there is a way to show the date of a previous day and time, this post shows how to post previous Sunday (using "week") and Monday (using "isoweek), but I would like to show other days.

For example:
If the report updates every Sunday so the last update is:

DATETIME_SUB(DATETIME_TRUNC(CURRENT_DATE("-6"), WEEK), INTERVAL 1 WEEK)

If the report updates every Monday so the lasta update is:

DATETIME_SUB(DATETIME_TRUNC(CURRENT_DATE(), ISOWEEK), INTERVAL 1 WEEK)

When the report updates every Friday 8am, what date is it?

Here´s my example report: https://datastudio.google.com/reporting/3bf62f5c-5251-440a-a28a-1a005e2e0fc2

google-data-studio

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'How to show the previous day and time date and specific hour in Data Studio?

Sources

Related Questions