It would be a huge asset for KPI monitoring on dashboards if you could stack filters,
example “this month” being all octobers + stacked with “this year” or “last year”
this way you could have filters that updated month to month without you having to adjust them.
resolved this myself with a simple block, change ‘sale date’ to whatever column it is you need the date pulled from then simply make a filter on the formula column of only showing true
IF(
AND(
MONTH({Sale Date}) = MONTH(TODAY()),
YEAR({Sale Date}) = YEAR(TODAY()) - 1
),
“TRUE”,
“FALSE”
)