Year-over-year growth in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sales data for two years: 2022 and 2023

Cell	Value
A1	Year
B1	Sales
A2	2022
B2	1000
A3	2023
B3	1200

Formula Trace

YoY Growth = DIVIDE(SUM(Sales) - CALCULATE(SUM(Sales), SAMEPERIODLASTYEAR(Date)), CALCULATE(SUM(Sales), SAMEPERIODLASTYEAR(Date)))

Step 1: SUM(Sales) for 2023

Step 2: CALCULATE(SUM(Sales), SAMEPERIODLASTYEAR(Date)) for 2023

Step 3: SUM(Sales) - CALCULATE(SUM(Sales), SAMEPERIODLASTYEAR(Date))

Step 4: DIVIDE(200, 1000)

Step 5: 0.2 as percentage

Cell Reference Map

    A      B
1 | Year | Sales |
2 | 2022 | 1000  |
3 | 2023 | 1200  |

Arrows:
B3 (1200) --> SUM(Sales)
B2 (1000) --> SAMEPERIODLASTYEAR(Sales)

The formula uses sales values from 2023 (B3) and 2022 (B2) to calculate growth

Result

    A      B           C
1 | Year | Sales | YoY Growth |
2 | 2022 | 1000  |            |
3 | 2023 | 1200  |   20%     |

The YoY Growth column shows 20% growth for 2023 compared to 2022

Sheet Trace Quiz - 3 Questions

What is the sales value used for the current year in the formula?

A 1000

B 1200

C 200

D 20%

Key Result

Year-over-year growth = (Current Year Sales - Previous Year Sales) / Previous Year Sales