Not exactly answer your question but....
This week: DATEPART('week', TODAY())
Previous: DATEPART('week', TODAY()) - 1
Hi Adam Anie
Here I have attached one screen shot which shows last 51 and 52 week sales data of every year and week is in your format YYYYWW
Please let me know if you have any question for this.
Please mark correct and helpful if it works for you.
Thanks. Actually my intention is to find the latest 2 weeks data out of many weeks. I guess it will be good to use calculated field.
Also I knew that in this case I can use filtering including with condition but every time I opened the saved workbook I have to set the filtering again. I'm not sure why it happened.
Example - setting latest 2 week