Creating Date Range Filter with Dynamic End Date = Max Date

Since the version 2020.1, Tableau has a new dynamic parameter feature that solves a long standing problem: Making a date range filter with end date default to the max date in the data source.

Here is how it works:

1.Create a field Max Date = {Max(Order Date)}

2.Create a parameter End Date as follows. Set value when workbook opens to be the above Max Date.

3.Create your regular Start Date parameter and a date range filter

Here we got an example workbook for you to download. It will always open to the last date of the data set as the End Date.

Update: I found an issue when working with data extract on server. The solution is 

1. Create a local copy of the extract.
2. Create Max Date and publish data extract to the server along with the field.

Then the dynamic parameter works.