Why intermediate DAX solves business questions in Power BI - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to calculate total sales using DAX.

Power BI

Total Sales = SUM([1])

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

ASales[Amount]

BSales[Date]

CCustomers[Name]

DProducts[Category]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-numeric column like date or name inside SUM.

The SUM function adds all values in the Sales[Amount] column to get total sales.

2fill in blank

medium

Complete the code to calculate average sales per customer.

Power BI

Average Sales = DIVIDE(SUM(Sales[Amount]), [1])

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

ASUM(Customers[CustomerID])

BDISTINCTCOUNT(Sales[CustomerID])

CCOUNT(Sales[Amount])

DCOUNTROWS(Products)

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT which counts all rows, not unique customers.

DISTINCTCOUNT counts unique customers to divide total sales by number of customers.

3fill in blank

hard

Fix the error in this DAX measure to calculate sales growth percentage.

Power BI

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

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

APREVIOUSYEAR(Sales[Date])

BNEXTYEAR(Sales[Date])

CPREVIOUSMONTH(Sales[Date])

DSAMEPERIODLASTYEAR(Sales[Date])

Attempts:

3 left

💡 Hint

Common Mistakes

Using PREVIOUSYEAR which returns the whole previous year, not the same period.

SAMEPERIODLASTYEAR returns the same period last year for correct year-over-year comparison.

4fill in blank

hard

Fill both blanks to create a measure that counts customers with sales over 1000.

Power BI

High Value Customers = CALCULATE(DISTINCTCOUNT(Sales[CustomerID]), FILTER(ALL(Sales), Sales[Amount] [1] [2]))

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

A>

B1000

C<

D500

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' or wrong threshold values.

The filter keeps sales where amount is greater than 1000 to count those customers.

5fill in blank

hard

Fill all three blanks to create a measure that calculates total sales for the current year.

Power BI

Total Sales CY = CALCULATE(SUM(Sales[Amount]), [1](ALL(Sales[Date]), [2](Sales[Date]) = YEAR([3]())))

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

AFILTER

BYEAR

CTODAY

DALL

Attempts:

3 left

💡 Hint

Common Mistakes

Using ALL which removes filters, or missing TODAY function.

Use FILTER to filter dates where YEAR equals the current year from TODAY function.