In this video I am comparing the performance of two calculated tables, one based on the offset function the other on the window function. I am calculating current year sales vs previous year sales, in a defined partitioning possible through these functions.