Thank you for your response
But i am not showing the Date field itself in the table hence the above formula won't show any data. I had mentiond that in the question itself
1 of 2 people found this helpful
Can you use the below calculation which will help you to have values even if you are moving ahead to a new year
DATEDIFF('month',[DATE],[today])<=3 and DATEDIFF('month',[DATE],[today])>=1
DATE = Database filed.
Use this calculation in the filter which only fetches the last 3 months.
thanks for the response
I suspect that this formula won't work when I run this report in JAN,2017. I ran the calculated field provided by you with the [today] calc. field which ahs Jan,2017 date and it didn't work. this is the same reason why I had taken the today as a calc. field
Hi Animesh ,
I am also stuck with same issue.
I need to use 3 months data i.e. Current Month-1 in One calculation .
I am using MONTH([Month])=MONTH(TODAY())-1 ,MONTH([Month])=MONTH(TODAY())-2 ,MONTH([Month])=MONTH(TODAY())-3 to take last 3 months data. Here Month is data field.
But on Year change it is not working.
Could you please suggest any workaround.
I have been trying to do this as well. The issue seems to be I cannot create a range of dates based off the max date of the date filter in the view.
I likewise want to show the past 3 months of a Measure where my anchor date is actually the max date that gets set by the user with a dashboard date range slider. This is possible when using a window max or a datediff with filter as show above, but I only want to show the measure in my view, and not the extra columns. To actually get this to work based of a dynamic anchor date seems impossible.