You can create a calculated field with formula "Today()-1" and the use the calculated field everywhere instead of "Today()", so there is one calculated field that must be changed if required.
Is this is what you were looking for?
Yesterday: DATEADD('day',-1, TODAY() )
Last day last month: DATEADD('day',-1, DATETRUNC('month', TODAY() ) )
Did you consider the use of a parameter field called "month-end" and then simply set this to the date you want month-end to be.?
Simple to reference the parameter in your reporting formula so setting it once all formulae would be updated.
Hope this helps.
Thanks for the responses everyone.
My quandary is that I've already created the report and I have a number of calculated fields using today() (bad planning, I know). Rather than re-code these calculated fields, I want Tableau to believe that today() is actually today() minus whatever. So my question is, where does Tableau get the value from today() from?
If it matters, I'm rolling back the date just for a demo. This isn't something I plan on using in 'production'.
Go to your Windows calendar and set it to yesterday. Then you won't have to change any of your calcs.