Last Modified Date: 08 Dec 2017
- Tableau Desktop
AnswerFollow these steps:
Create a Table Calculation with the following formula:
LOOKUP(MIN(DATETRUNC('quarter', [Your Date Field])),0)
(Optional - Formatting) This calculation uses Continuous Quarter. The default date format is 01/01/2014. To change that, for example for 2014 Q1, right click on the newly created field, select Default Properties > Date Format.
Drag the new field to filter. Right click on the filter and select Compute Using > [Your Date Field]