Forum Discussion
Show values for items NOT in current month
Hi all,
I'm kicking myself over this one... it is Monday here after all.
I have items that include a date value, number value, title (text), and a status (text). I currently have a chart setup that shows these values for the current month using the Relative Date Filter Type>Current Month in report view. The query these items are being generated from includes all dates from the past year. Simple.
I've been asked to include a seperate chart that includes all items of a specified status that are NOT from the current month.
Filtering by status is easy as pie, it's getting the date field to only show all items except from this month where I'm having trouble.
What is the best way to achieve this?
Thanks!
You can either use "advanced filtering" instead of relative dates (maybe obvious) but then you would have to select the specifc date you want for the cut-off rather than a relative date.
The other option is to introduce a slicer on dates into your view.
4 Replies
- erik_tarnvik
Solution Specialist
You can either use "advanced filtering" instead of relative dates (maybe obvious) but then you would have to select the specifc date you want for the cut-off rather than a relative date.
The other option is to introduce a slicer on dates into your view.
Thanks for the reply Erik. I ended up going with your second option and added a custom column for 'IsCurrentMonth'. I completely forgot about that option this morning and needed something that would roll over month to month. For those interested:
IsCurrentMonth = IF(MONTH('Table Name'[Date])=Month(NOW()), "Current Month", "Other")
Sliced it using the 'Other' option and was good to go.
Cheers!
- erik_tarnvik
That works! Pretty good for a Monday...
