Year-over-year growth in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does Year-over-year (YoY) growth measure in business data?

Year-over-year growth measures how a value, like sales or revenue, changes compared to the same period in the previous year. It helps see if the business is growing or shrinking over time.

intermediate

Write a simple DAX formula to calculate Year-over-year growth percentage for Sales.

YoY Growth % = DIVIDE( SUM(Sales[Amount]) - CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Date[Date])), CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Date[Date])) ) * 100

beginner

Why is it important to use a proper date table when calculating Year-over-year growth in Power BI?

A proper date table ensures correct time intelligence calculations. It helps DAX functions like SAMEPERIODLASTYEAR work correctly by providing continuous dates and proper relationships.

beginner

What visual type is best to show Year-over-year growth trends over months?

A line chart is best because it clearly shows changes over time and trends month by month, making it easy to compare current year and previous year growth.

intermediate

Explain what happens if you calculate YoY growth without filtering the same period last year.

If you don't filter the same period last year, the comparison will be wrong. You might compare current sales to total sales from last year or a wrong date range, giving misleading growth results.

Which DAX function helps to get the same period last year for YoY calculations?

A SAMEPERIODLASTYEAR

B TOTALYTD

C DATESBETWEEN

D FILTER

SAMEPERIODLASTYEAR returns the dates from the same period in the previous year, perfect for YoY comparisons.

What does a positive Year-over-year growth percentage indicate?

A Decrease compared to last year

B Increase compared to last year

C No change compared to last year

D Data error

A positive YoY growth means the value increased compared to the same period last year.

Which visual is NOT ideal for showing Year-over-year growth trends?

A Combo chart

B Bar chart

C Line chart

D Pie chart

Pie charts show parts of a whole, not trends over time, so they are not suitable for YoY growth.

What is the first step before calculating YoY growth in Power BI?

A Create a date table

B Add a pie chart

C Import images

D Write SQL queries

A date table is essential for time intelligence functions to work correctly.

If Sales this year are 120 and last year were 100, what is the YoY growth percentage?

A 100%

B 83%

C 20%

D 120%

YoY growth % = ((120 - 100) / 100) * 100 = 20%

Describe how to calculate Year-over-year growth in Power BI using DAX.

Think about comparing current and previous year values using time intelligence.

Explain why Year-over-year growth is useful for business decision making.

Consider how comparing the same time periods year to year helps understand trends.