We conceptually need to ‘hide’ those values and not filter them. To do this we will manipulate where this filter happens in the query pipeline, and by using a Table Calculation, we can make it happen all the way at the end, after the YoY calcs have already been computed.
Write a calc like this:
minOver(min({order date}), [{order date}])
And then put your filter on that. Should work!
Before:
After:
