Why advanced DAX handles complex scenarios in Power BI - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to calculate total sales using SUM function.

Power BI

Total Sales = SUM([1])

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

AProducts[Category]

BSales[Date]

CCustomers[Name]

DSales[Amount]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-numeric column like Sales[Date] causes errors.

Trying to sum a text column like Customers[Name].

The SUM function needs a numeric column to add up. Sales[Amount] contains the sales values.

2fill in blank

medium

Complete the code to calculate average sales per customer.

Power BI

Average Sales = AVERAGEX([1], Sales[Amount])

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

ACustomers

BRegions

CProducts

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales table directly causes incorrect aggregation.

Choosing unrelated tables like Products or Regions.

AVERAGEX iterates over Customers to calculate average sales per customer.

3fill in blank

hard

Fix the error in the code to calculate sales for the current year.

Power BI

Sales CY = CALCULATE(SUM(Sales[Amount]), YEAR(Sales[Date]) = [1])

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

ADATE()

BYEAR(TODAY())

CNOW()

DTODAY()

Attempts:

3 left

💡 Hint

Common Mistakes

Using TODAY() directly causes type mismatch.

Using NOW() returns date and time, not just year.

YEAR(TODAY()) extracts the current year number to filter sales by year.

4fill in blank

hard

Fill both blanks to calculate sales growth percentage compared to previous year.

Power BI

Sales Growth % = DIVIDE(SUM(Sales[Amount]) - CALCULATE(SUM(Sales[Amount]), [1]), CALCULATE(SUM(Sales[Amount]), [2]))

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

ASAMEPERIODLASTYEAR(Sales[Date])

BPREVIOUSYEAR(Sales[Date])

CNEXTYEAR(Sales[Date])

DDATESYTD(Sales[Date])

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing different time intelligence functions causes wrong results.

Using NEXTYEAR or DATESYTD is incorrect for previous year comparison.

PREVIOUSYEAR filters sales to last year for both numerator and denominator calculations.

5fill in blank

hard

Fill all three blanks to create a measure that calculates cumulative sales up to the selected date.

Power BI

Cumulative Sales = CALCULATE(SUM(Sales[Amount]), FILTER(ALL(Sales[Date]), Sales[Date] [1] MAX(Sales[Date]) [2] [3]))

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

A<=

B>=

C&&

D||

EMAX(Sales[Date])

Attempts:

3 left

💡 Hint

Common Mistakes

Using || (OR) instead of && (AND) changes the logic.

Using >= instead of <= reverses the date filter.

The FILTER keeps all dates less than or equal to the max date, combining conditions with AND (&&).