Forum Discussion
duncanwarrick
8 years agoNew Member
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
Create a calculated column
same period last year = SAMEPERIODLASTYEAR(Sheet3[date])
Best Regards
Maggie
1 Reply
- v-juanli-msftCommunity Support
Create a calculated column
same period last year = SAMEPERIODLASTYEAR(Sheet3[date])
Best Regards
Maggie