Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

What if my table has date as a column? something like this
image
wouldn’t it just show those values as zero rather than actually filtering the unwanted rows out?