You can use a window calculation to filter your dates, something like WINDOW_MAX(max([timeUnit])) computed along cell. You can then use this as a filter. You users will be able to select specific months without compromising the calculation.
Check the attached for a sample solution.
sample solution.twbx 363.8 KB