Year-over-year growth in Power BI - Step-by-Step Guide

Introduction

Year-over-year growth shows how a value changes compared to the same time last year. It helps you see if sales, revenue, or other numbers are improving or declining over time.

When you want to compare this year's sales to last year's sales for the same month.

When your marketing team needs to see if website visits increased compared to last year.

When you track monthly revenue and want to highlight growth or decline from the previous year.

When you prepare a financial report showing yearly performance changes.

When you want to create a dashboard that updates automatically with new yearly data.

Steps

Step 1: Open your Power BI Desktop file

- Power BI Desktop main window

Your report and data model are visible on screen

Step 2: Click on the Modeling tab

- Ribbon at the top

Modeling options appear below the ribbon

Step 3: Click New measure

- Modeling tab

A formula bar appears to enter a DAX expression

Step 4: Type the following DAX formula for year-over-year growth: YoY Growth = DIVIDE(SUM(Sales[Amount]) - CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Date[Date])), CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Date[Date])))

- Formula bar

A new measure named YoY Growth is created in your model

Step 5: Add a visual like a card or line chart to your report

- Visualizations pane

The visual appears on the report canvas

Step 6: Drag the YoY Growth measure to the Values field of the visual

- Visualizations pane fields

The visual shows the year-over-year growth percentage

Step 7: Add a date field to the Axis or Legend of the visual

- Visualizations pane fields

The visual breaks down growth by year or month for comparison

Before vs After

Before

Report shows total sales by month without comparison to last year

After

Report shows year-over-year growth percentage for each month, highlighting increases or decreases

Settings Reference

New measure

📍 Modeling tab in Power BI Desktop

To write formulas that calculate year-over-year growth

Default: No measure created

Visual type

📍 Visualizations pane

Choose how to display the year-over-year growth data

Default: Card

Date field

📍 Fields pane

Used to compare current and previous year data

Default: Date

Common Mistakes

Using a date field without a proper date table

SAMEPERIODLASTYEAR requires a continuous date table to work correctly

Create or use a proper date table marked as a date table in Power BI

Not using DIVIDE function and dividing by zero

Direct division can cause errors if last year's value is zero

Use DIVIDE function which safely handles division by zero

Summary

Year-over-year growth compares current values to the same period last year.

Create a new measure using DAX with SAMEPERIODLASTYEAR and DIVIDE functions.

Ensure you have a proper date table for accurate time intelligence calculations.