How do I make my graph below to show all of 2016 and 2017 will only be from Jan to Nov 2017? So always exclude any dates after previous month of current year.
I tried:
If month([Date]) <= month(DATETRUNC('month', today())-1)
then 'Last Month'
else 'Not last Month'
end
Used the calc above to filter to only Last Month but Dec 2016 was not showing. Thanks!
I think what you have is close, try this:
if DATETRUNC('month', [DATE]) < DATETRUNC('month', TODAY())
then "Prior Month"
else "This Month"
End
You could leave "Prior Month" in the filter and exclude "This month"
Oh wait...I see you are doing this for LAST YEAR. Hang on...I will update.
OK, try this...this will give you a boolean. You can add to the filter shelf and exclude "FALSE".
YEAR([DATE]) < YEAR(today())
and
DATETRUNC('month', [DATE]) < DATETRUNC('month', DATEADD('year',-1,today()))