IF DATETRUNC('month', TODAY())=DATETRUNC('month', [My Date]) THEN 'Hide that #!#@% dip' ELSE 'Show' END
DISCLAIMER: This is off the top of my head and has not been tested on your workbook (the one you didn't post).
Ahh! So glad it helped James. And welcome to the forums!
So this works for 'month', but is there a more generic solution? Ideally, one would want to suppress displaying the data from ANY current period (since data for a partial period can be misleading, as james.diaz implies). Is it possible to determine within a calculation the aggregation level of a date? That would at least facilitate a CASE statement to handle this behavior.
I put in a suggestion earlier this year for this type of behavior to be added to the "Relative Date" quick filter:
I'll have to start banging the drum for support for this again...maybe we can get in Tableau 9!
If you have a historical dashboard that looks at everything from say 1999 to yesterday, but your data includes today or even future dates, then you can exclude today and future dates with this simple calculated field:
Then add this calculated field to the filter section of one of your sheets (not inside the dashboard). Once you add it you can then apply it to all other sheets that are used in your dashboard.