KNOWLEDGE BASE

How To Create A Filter For The First Date And Last Date Of The Selected Year


Published: 30 Oct 2020
Last Modified Date: 02 Nov 2020

Question

How to create a filter for the first date and last date of the selected year 

Environment

  • Tableau Desktop

Answer

1. Make a parameter like below where the values are end of year dates
User-added image
2. Calculated field - First date of year
DATE(DATETRUNC('year',[Parameter 1]))

3. Calculated field - Last date for year
 [Parameter 1]

4. Drag to filters and Show filters
 
Did this article resolve the issue?