MTD & QTD formula does not work when using time filter

Hi there,  When using a MTD forumula, when I choose a prior and current time period, everything is fine, but when I go to 2023, unless I specifically go into trickle down to the exact month I am in ...