Thanks for checking out this video! To learn more, check out our upcoming classes, webinars and office hours here: ------ In the past, we’ve covered how to write a calculation which allows you to compare today to the same day of the year in Tableau ( ). In that scenario, we used the day of year number for comparison. That works well if, for instance, January 27th from this year should be compared to January 27th of last year. However, what if you want to compare so that today is being compared to the equivalent weekday from last year? For example, maybe it’s important to know how the 4th Friday in January this year compares to the 4th Friday in January last year. If that’s the case, you aren’t trying to compare to the SAME day as last year but rather the EQUIVALENT day. Check out the video below to learn how you can use Tableau table calculations to perform this form of comparison! Example Tableau Workbook Here: Full list of steps with calculations written out here: - - - 0:00 Introduction 3:22 Current Year Parameter 4:30 Syncing Previous Year Dates to Current Year Dates 6:16 Relative Date Calculation (Year Labels) 7:33 Calculation to Filter to Current/Previous Years Only 9:52 Calculation to Hide Previous Year Column 10:50 Growth Percent Calculation 14:12 Formatting 14:40 Current Year and Previous Year Values (For Tooltip) 16:07 Outro and Steps Listed Out