You can create a calculated field as shown below and add it to the filter to display the required data.
IF DATEPART("quarter",[Date Field A])=DATEPART("quarter",TODAY())
OR DATEPART("quarter",[Date Field B])=DATEPART("quarter",TODAY())
A 10.5 workbook is attached.
Date Filters.twbx 17.6 KB
Hi, again. I'm going to make this a bit more difficult.
- Pivot doesn't seem to work. From my quick research, it might not be available if I use Redshift as my data source.
- Our fiscal year starts in February, which is not recognized by the date functions.
Any ideas on how to resolve this?
You can create a calculated field to assign the corresponding quarter for each of your dates. You can similarly create another calculated field to assign the quarter for the current date, and then have a calculated field to include/exclude the data as in the solution I gave above.