Forum Discussion
Solved
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 setu...
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.
erik_tarnvik
Solution Specialist
Solution SpecialistThat works! Pretty good for a Monday...
For data that spans multiple years this would be more robust:
IsCurrentMonth = IF(AND(MONTH('Table Name'[Date])=Month(NOW()),YEAR('Table Name'[Date])=YEAR(NOW())),1,0)
Using 1 and 0 will work better in report service than text or boolean based filtering I find.