This content has been marked as final. Show 1 reply
Hi Valeria! Here are some options for you:
- You can set up a calculated field that compares the as-of date dimension to the TODAY() function. If you need to offset the date, you can use DATEADD().
- If the latest date in your data source is the one that you want as the preset, you can create a filter that gets the top 1 date from the data source (using MIN() or MAX()).