Forum Discussion

duncanwarrick's avatar
duncanwarrick
New Member
8 years ago
Solved

Relative date filter using historical date

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

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi duncanwarrick

    Create a calculated column

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

     

    Best Regards

    Maggie