Year-over-Year Growth

Year-over-Year (YoY) growth is used to compare a metric for the current year with the same metric in the previous year. It helps businesses track annual performance, identify trends, and measure growth over time.

YoY growth is commonly applied to metrics such as sales, revenue, profit, or customer count.

Key Concept

YoY calculations require a Date Table marked as a Date Table in Power BI. Measures are used to calculate values for the current year and the previous year.

DAX Example – Basic YoY Growth

Step 1: Total Sales Measure

Total Sales = SUM(Sales[Amount])

Step 2: Previous Year Sales Measure

Sales LY = CALCULATE(
    [Total Sales],
    SAMEPERIODLASTYEAR(DateTable[Date])
)

• SAMEPERIODLASTYEAR shifts the filter context to the same period in the previous year.

Step 3: YoY Growth Percentage

YoY Growth % = 
DIVIDE(
    [Total Sales] - [Sales LY],
    [Sales LY],
    0
)

• Calculates the percentage change compared to the same period last year.
• Returns 0 if the previous year has no data.

Visualizing YoY Growth

• Use line charts to show trends over years.
• Use column or bar charts to compare current vs. previous year values.
• Use cards or KPI visuals to display YoY growth percentages clearly.

Best Practices

• Always use a dedicated Date Table with continuous dates.
• Mark the Date Table as a Date Table in Power BI to enable proper time intelligence functions.
• Combine YoY growth with MoM and YTD metrics for comprehensive time-based analysis.
• Ensure labels and titles are clear to show which year is being compared.

Conclusion

Year-over-Year growth is an essential metric for tracking annual performance and understanding business trends. Using DAX functions like SAMEPERIODLASTYEAR with CALCULATE, you can create dynamic YoY measures in Power BI for interactive and insightful reports.