How to Show Data for Only Completed Periods

In this tip, I show you how to filter your data to only completed weeks. This method can be extended to completed months, quarters or years. All you have to do is swap out the word 'week' in the filter calculation.