Press "Enter" to skip to content

Week-Over-Week Comparisons with Power Query

Gilbert Quevauvilliers knows that time is a flat circle:

I have seen in the past Week-on-Week comparisons but one of the challenges is what happens when it overlaps years. Especially at the start of a year like it is now Feb 2021, the users want to compare week-on-week for the past 3 months.

My challenge was to find a way to have a continuous week number over multiple years.

Click through to learn how.