Have a look at Date hider logic [ https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Calculation-Year-over-Year-Table-with-Filtering-aka-Date-Hider-]
I believe this is almost similar to the ask here : How do I superimpose a period over period in a visual without having the period that I'm comparing it to in the visual? - #3 by e2s
Kind regards,
Koushik