I want to create a calculated field as Previous Month based on a field in my table Date In:
DATETRUNC("month", [Date In]) = DATETRUNC("month", TODAY())-30
Is this condition correct?
It could be like this:
DATEDIFF ( 'month', DATETRUNC ( 'month', [Date In] ), DATETRUNC ( 'month', TODAY() ) ) = 1
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...