Filter and Slicer affecting the report

[Anonymous]

Dear Altriusts,

I have a report which is showing the last 12 months data only. and current month in the same report page but seperately. 

See the screenshot. 

The calender Higherchy for that report is like below:

This report filter (first image) indicating filter and slicer affecting the report but I am able to find out any slicer and I am confused how this calander is rolling over last 12 months. 

I want to recreate this kind of report for other report requirements using this logic or any otehr suggestion is highly appreciable. 

Thanks in advance !

How to calculate last 12 months 

[amitchandak]

@Anonymous , One way is follow this video

https://www.youtube.com/watch?v=duMSovyosXE

other is to have these two flags and filter them at the visual level filter

Month Type = Switch( True(),
Date([Date]) = eomonth(Today(),-1),"Last Month" , //Last Month
Date([Date])= eomonth(Today(),0),"This Month" , //This Month
[Month Year]
)

lasr 12 Months Type = Switch( True(),
Date([Date]) >= eomonth(Today(),-11) && Date([Date])<= eomonth(Today(),0) ,"Last 12 Months" , //Last Month // or use -12
Date([Date])= eomonth(Today(),0),"Other Months" , //This Month
[Month Year]
)

[Anonymous]

@amitchandak where i would need to add these two flags in my calander function or need a new one. 

[amitchandak · Accepted solution]

@Anonymous , add in your calendar as new columns and the add as a visual level filter based on need