Date Filter Last 7 Days From Max Date

[sharc316]

Hi,

I would like to set the date range filter default value to display last 7 days starting from max date in the available data.

Can anyone suggest how this can be done?

Thank you for your help.

[GilbertQ]

Hi @sharc316

There are multiple ways to do this.

If you have a date table, you could create a column in the Query Editor which will look at the Max Date, and then go back 1 week or 7 days. And then you give this new column a value for example of "Last 7 Days" and for the else part you use "Older than 7 Days"

Then once this loads you can then use this column in your filter.

Another option is to do it using a measure, using the DATEDIFF

[sharc316]

Thank you for the help. Will give it a try.