How to compare MTD vs same MTD from 2 years ago dynamically in Looker Studio?

Looker Q&A Looker Studio
1

I’m trying to create a dynamic comparison in Looker Studio where:

  • Current period = Month to date (e.g., Jan 1–22, 2026)

  • Comparison period = Same month and same days from 2 years ago (e.g., Jan 1–22, 2024)

I’ve tried using:

  • Date Range Control (This month to date)

  • Comparison date range → Custom → Advanced → Today − 2 Years (for both start and end)

However, Looker Studio converts this into a fixed calendar range (e.g., full year 2024) instead of aligning the same MTD days.

Question:
Is it possible to achieve MTD vs same MTD (2 years ago) dynamically using native date controls, or is blended data / calculated date shifting the only solution?

If blending is required, what is the recommended approach or best practice?

Thanks in advance!

2

Hi there,

Blended is the way to go, more on this here: How to do a year to date, year over year comparison in Looker Studio? or How to make a same day last year comparaison in Looker Studio? And from there play with the formulas to do the MTD Vs MTD 2yo