What Is Year-over-Year (YoY) Analysis?
Year-over-year analysis compares a metric in one period to the same period a year earlier, this June against last June, this quarter against the same quarter last year. The comparison answers a question every business asks: are we growing, and by how much, against where we were a year ago. Because it lines up matching periods, YoY is one of the most common and trusted ways to measure performance over time.
Its power is in what it controls for. Many businesses are seasonal, and comparing this month to last month can mislead when the two months are simply different by nature. Comparing to the same period last year removes that seasonal distortion and shows the real trend underneath.
How to Calculate Year-over-Year
Year-over-year change is the difference between a period and the same period one year earlier, expressed as a percentage of the earlier figure.
YoY % = (Current Period – Prior Year Period) / Prior Year Period
Worked example:
- Revenue this June: $1,200,000
- Revenue last June: $1,000,000
- YoY change: (1,200,000 – 1,000,000) / 1,000,000 = 20%
The same formula works for any metric and any matching period, this quarter against the same quarter last year, this month against the same month last year.
Year-over-Year in Power BI (DAX)
In Power BI, year-over-year relies on a marked date table and the time intelligence functions. The pattern below compares revenue to the prior year; replace the measure and date table names with the ones in your model:
Revenue PY =
CALCULATE ( [Total Revenue], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
Revenue YoY % =
DIVIDE ( [Total Revenue] - [Revenue PY], [Revenue PY] )SAMEPERIODLASTYEAR shifts the date filter back one year. A continuous, marked date table is required for it to work correctly.
Why Compare to the Same Period Last Year?
Seasonality is the reason. A retailer’s December is always bigger than its January; a tax firm’s spring is always busier than its summer. Comparing consecutive periods in a seasonal business measures the season as much as the performance. Year-over-year sidesteps this by comparing like with like, December to December, so a change reflects real movement rather than the calendar.
This makes YoY especially useful for judging genuine growth and for spotting turning points. A YoY figure that has been positive and starts shrinking is an early signal worth attention, in a way a noisy month-to-month number would obscure.
YoY vs Other Comparisons
Year-over-year is one of several time comparisons, each answering a different question. Sequential, or period-over-period, comparison looks at this period versus the immediately prior one, useful for short-term momentum but vulnerable to seasonality. Year-to-date accumulates from the start of the year, useful for pacing against an annual target. YoY compares matching periods across years, best for underlying trend.
These are complementary, not competing. A complete view often shows all three together, and they are all expressions of the same underlying capability, time intelligence, applied to answer different questions.
The Data Behind Reliable YoY
Reliable year-over-year analysis needs a clean, continuous history and a proper date dimension to align periods correctly. The data has to reach back far enough to compare, and it has to be consistent, a metric defined the same way this year and last, or the comparison is apples to oranges. Changes in how the business records data over time can quietly break a YoY comparison if the foundation does not account for them.
This is why dependable YoY is a product of a sound model as much as a formula. With history aligned and definitions consistent, year-over-year becomes a trustworthy standing view rather than a number that has to be hand-checked each time.
Frequently Asked Questions
What is year-over-year analysis?
It compares a metric to the same period one year earlier, such as this quarter against the same quarter last year. By aligning matching periods it removes seasonal distortion and reveals the true underlying trend, which makes it one of the most trusted ways to measure performance over time.
How do you calculate year-over-year in Power BI?
Use a marked date table with the time intelligence function SAMEPERIODLASTYEAR to pull the prior-year value, then divide the change by it: DIVIDE ( [Measure] – [Measure PY], [Measure PY] ). The result is the year-over-year percentage.
Why use year-over-year instead of month-over-month?
Because many businesses are seasonal, and comparing consecutive periods measures the season as much as the performance. Year-over-year compares like with like, the same period across years, so a change reflects real movement rather than the natural rhythm of the calendar.
What is the difference between YoY and YTD?
Year-over-year compares a period to the same period a year earlier to show underlying trend. Year-to-date accumulates a metric from the start of the year to the current point, used to pace against an annual target. They answer different questions and are often shown together.
YoY Analysis and QuickLaunch’s Approach
QuickLaunch Analytics builds the clean history, consistent definitions, and proper date dimension that make year-over-year analysis dependable, so the comparison reflects real performance rather than data quirks. Leaders get trustworthy YoY trends as a standing view, on a foundation refined across 250+ enterprise implementations.
