Thanks Deepak, Unfortunately neither option seems to work.
Option 1: "Latest Date Preset" is ideal but seems not available for table calc filter, as I mentioned
Option 2: gives fixed value instead of default value. In my example, I would like the filter to default to June but still be able to select May or April. However this fixes the filter to June.
Option 3: did not change anything. Not completely sure.
Option 4: Date part is not selectable when moving the table calc filter to the Filters shelf