I think I've found a simple and elegant solution to this problem (in most cases) by creating a new beast mode date field based on the original date field in my dataset: CASE WHEN DAY(CURRENT_DATE) = 1 THEN DATE_ADD(`date`, INTERVAL 1 MONTH) ELSE `date` END Using this beast mode date field in a card date range filter allows…