If you create a custom field with the following, with [date] as the date from your data, and use it as an exclude filter along with the 4 months relative date it will exclude the current month.
month([date]) = month(today())
year([date]) = year(today())
Thanks for your reply Chris.
Not sure if I understood your approach. Its not the view filter, Data source filter editor allows to filter on one field at a time.
Also, Tableau does not allow to create two datasource filters on the same field.
Any other approach?
Sorry, I misread your question slightly there - I was working on view filters.
What is the data source that you're using? You could do it using Tableau Prep if that is an option.
If not duplicating the date field would allow you to run two filters on it, and you could then hide it.
Thanks Chris, for the idea of using expression. I ended up creating a T|F calculated field by comparing <date-field> with <current-date>-8months and +4months. And keeping only TRUE rows.