TOTALYTD, TOTALQTD, TOTALMTD in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to calculate the year-to-date total sales.

Power BI

Total Sales YTD = TOTALYTD(SUM(Sales[Amount]), [1])

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

ASales[Amount]

BSales[Date]

CSales[Product]

DSales[Customer]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-date column like Sales[Amount] or Sales[Product] as the date argument.

The TOTALYTD function needs a date column to calculate year-to-date totals correctly. Here, Sales[Date] is the correct date column.

2fill in blank

medium

Complete the code to calculate the quarter-to-date total sales.

Power BI

Total Sales QTD = TOTALQTD(SUM(Sales[Amount]), [1])

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

ASales[Date]

BSales[Customer]

CSales[Amount]

DSales[Product]

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales[Amount] or other non-date columns as the date argument.

TOTALQTD needs the date column to calculate the total for the current quarter. Sales[Date] is the correct choice.

3fill in blank

hard

Fix the error in the code to calculate month-to-date total sales.

Power BI

Total Sales MTD = TOTALMTD(SUM(Sales[Amount]), [1])

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

ASales[Amount]

BSales[Product]

CSales[Date]

DSales[Customer]

Attempts:

3 left

💡 Hint

Common Mistakes

Passing Sales[Amount] or other non-date columns as the date argument.

The TOTALMTD function requires a date column to calculate month-to-date totals. Using Sales[Date] fixes the error.

4fill in blank

hard

Fill both blanks to calculate year-to-date sales filtered by product category.

Power BI

Total Sales YTD Category = CALCULATE(TOTALYTD(SUM(Sales[Amount]), [1]), Sales[Category] [2] "Bikes")

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

ASales[Date]

B=

C!=

DSales[Amount]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-date column in the first blank.

Using '!=' instead of '=' in the filter condition.

The first blank needs the date column Sales[Date] for TOTALYTD. The second blank is the equals sign = to filter the category to "Bikes".

5fill in blank

hard

Fill all three blanks to calculate quarter-to-date sales for a specific customer.

Power BI

Total Sales QTD Customer = CALCULATE(TOTALQTD(SUM([1]), [2]), Sales[Customer] [3] "John Doe")

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

ASales[Amount]

BSales[Date]

C=

DSales[Category]

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales[Date] instead of Sales[Amount] inside SUM.

Using wrong operators in the filter condition.

The first blank is the sales amount column Sales[Amount] to sum. The second blank is the date column Sales[Date] for TOTALQTD. The third blank is the equals sign = to filter for customer "John Doe".