Year-over-year growth in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the DAX measure to calculate total sales.

Power BI

Total Sales = SUM(Sales[[1]])

Drag options to blanks, or click blank then click option'

ACustomer

BProduct

CDate

DAmount

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a non-numeric column like Date or Customer causes errors.

Using a column unrelated to sales values.

The SUM function adds all values in the 'Amount' column to get total sales.

2fill in blank

medium

Complete the DAX formula to calculate sales for the previous year.

Power BI

Sales LY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR([1]))

Drag options to blanks, or click blank then click option'

ACalendar[Date]

BSales[Date]

CCustomer[Date]

DProduct[Date]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a date column from the sales table instead of the calendar table.

Using a non-date column.

SAMEPERIODLASTYEAR needs a date column from a calendar table to work correctly.

3fill in blank

hard

Fix the error in the DAX measure to calculate year-over-year growth percentage.

Power BI

YoY Growth % = DIVIDE([Total Sales] - [Sales LY], [1]) * 100

Drag options to blanks, or click blank then click option'

A[Sales LY]

BCalendar[Date]

CSales[Amount]

D[Total Sales]

Attempts:

3 left

💡 Hint

Common Mistakes

Using current year sales as denominator gives wrong growth calculation.

Using a column instead of a measure in the denominator.

The denominator should be the previous year's sales to calculate growth relative to last year.

4fill in blank

hard

Fill both blanks to create a measure that calculates sales difference between years.

Power BI

Sales Difference = [1] - [2]

Drag options to blanks, or click blank then click option'

A[Total Sales]

B[Sales LY]

C[Sales PY]

DSUM(Sales[Amount])

Attempts:

3 left

💡 Hint

Common Mistakes

Using raw SUM instead of measures causes inconsistent results.

Mixing up current and previous year sales in subtraction.

Subtract previous year sales from current year sales to get the difference.

5fill in blank

hard

Fill all three blanks to calculate year-over-year growth with error handling.

Power BI

YoY Growth % = DIVIDE([1] - [2], [3]) * 100

Drag options to blanks, or click blank then click option'

A[Total Sales]

B[Sales LY]

Attempts:

3 left

💡 Hint

Common Mistakes

Using current sales as denominator causes incorrect growth calculation.

Not using DIVIDE function can cause errors if denominator is zero.

The formula subtracts last year's sales from current sales, then divides by last year's sales to get growth percentage. Using DIVIDE handles division by zero safely.