Relative date filter using historical date

[duncanwarrick]

Hello, 

I am using the Relative date function to look at data for my last 30 days but I also want to be able to compare that with the same 30 day time frame from the year before... Any idea's on where to start? 

Thank you

[v-juanli-msft · Accepted solution]

Hi @duncanwarrick

Create a calculated column

same period last year = SAMEPERIODLASTYEAR(Sheet3[date])

Best Regards

Maggie