EARLIER for row context in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the DAX formula to calculate the difference between the current row's sales and the previous row's sales using EARLIER.

Power BI

Sales Difference = Sales[SalesAmount] - CALCULATE(SUM(Sales[SalesAmount]), FILTER(Sales, Sales[ProductID] = [1]))

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

ACURRENT(Sales[ProductID])

BSales[ProductID]

CPREVIOUS(Sales[ProductID])

DEARLIER(Sales[ProductID])

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales[ProductID] directly without EARLIER causes incorrect row context.

Using non-existent functions like PREVIOUS or CURRENT.

The EARLIER function is used to access the value of the current row in a nested row context, which is necessary here to compare the current product's sales with previous rows.

2fill in blank

medium

Complete the DAX formula to count how many sales have a higher amount than the current row using EARLIER.

Power BI

Count Higher Sales = COUNTROWS(FILTER(Sales, Sales[SalesAmount] > [1]))

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

ASales[SalesAmount]

BMAX(Sales[SalesAmount])

CEARLIER(Sales[SalesAmount])

DMIN(Sales[SalesAmount])

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales[SalesAmount] directly compares the same row to itself, giving wrong results.

Using aggregate functions like MAX or MIN instead of EARLIER.

EARLIER is needed to refer to the current row's SalesAmount inside the FILTER function to compare with other rows.

3fill in blank

hard

Fix the error in the DAX formula that tries to calculate the rank of sales by product using EARLIER.

Power BI

Sales Rank = COUNTROWS(FILTER(Sales, Sales[ProductID] = EARLIER(Sales[ProductID]) && Sales[SalesAmount] > [1])) + 1

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

AEARLIER(Sales[SalesAmount])

BSales[SalesAmount]

CMAX(Sales[SalesAmount])

DMIN(Sales[SalesAmount])

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales[SalesAmount] directly causes incorrect row context.

Using aggregate functions like MAX or MIN instead of EARLIER.

The formula needs EARLIER(Sales[SalesAmount]) to correctly compare each row's SalesAmount with the current row's SalesAmount in the FILTER.

4fill in blank

hard

Fill both blanks to calculate the cumulative sales amount per product using EARLIER.

Power BI

Cumulative Sales = CALCULATE(SUM(Sales[SalesAmount]), FILTER(Sales, Sales[ProductID] = [1] && Sales[Date] <= [2]))

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

AEARLIER(Sales[ProductID])

BSales[Date]

CEARLIER(Sales[Date])

DSales[ProductID]

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales[ProductID] or Sales[Date] directly without EARLIER.

Mixing EARLIER with non-related columns.

EARLIER(Sales[ProductID]) and EARLIER(Sales[Date]) are used to refer to the current row's product and date inside the FILTER to calculate cumulative sales correctly.

5fill in blank

hard

Fill all three blanks to create a calculated column that flags if the current sale is the highest for its product using EARLIER.

Power BI

Is Highest Sale = IF(Sales[SalesAmount] = CALCULATE(MAX(Sales[SalesAmount]), FILTER(Sales, Sales[ProductID] = [1] && Sales[Date] <= [2] && Sales[Date] >= [3])), TRUE(), FALSE())

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

AEARLIER(Sales[ProductID])

BEARLIER(Sales[Date])

CSales[Date]

DMAX(Sales[Date])

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales[ProductID] or Sales[Date] directly without EARLIER.

Using MAX(Sales[Date]) incorrectly inside FILTER.

EARLIER(Sales[ProductID]) and EARLIER(Sales[Date]) are used to refer to the current row's product and date inside the FILTER to find the highest sale correctly.