Power BI vs Tableau vs Excel comparison - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a simple measure that sums sales in Power BI.

Power BI

Total Sales = SUM([1])

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

ASales[Amount]

BProducts[Category]

CCustomers[Name]

DSales[Date]

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a non-numeric column like Date or Name.

The SUM function adds all values in the Sales Amount column.

2fill in blank

medium

Complete the code to filter data for the year 2023 in Power BI using DAX.

Power BI

Filtered Sales = CALCULATE(SUM(Sales[Amount]), Sales[Year] [1] 2023)

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

A=

B>

C<

D!=

Attempts:

3 left

💡 Hint

Common Mistakes

Using > or < which would filter other years.

The = operator filters rows where the year is exactly 2023.

3fill in blank

hard

Fix the error in this DAX measure to calculate average sales per customer.

Power BI

Avg Sales per Customer = DIVIDE(SUM(Sales[Amount]), [1](Customers[CustomerID]))

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

ASUM

BAVERAGE

CCOUNT

DCOUNTROWS

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNTROWS which counts table rows, not column values.

COUNT counts the number of customer IDs to divide total sales correctly.

4fill in blank

hard

Fill both blanks to create a calculated column that flags high sales over 1000.

Power BI

High Sales Flag = IF(Sales[Amount] [1] 1000, [2], "No")

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

A>

B"Yes"

C<

D"High"

Attempts:

3 left

💡 Hint

Common Mistakes

Using < instead of >, or returning incorrect text values.

The IF function checks if sales are greater than 1000 and returns "Yes" if true.

5fill in blank

hard

Fill the blank to create a measure that calculates sales growth percentage.

Power BI

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

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

AFILTER

BMIN

CCALCULATE

DMAX

Attempts:

3 left

💡 Hint

Common Mistakes

Using FILTER incorrectly or MIN instead of MAX for current year.

This formula calculates the difference between current year sales and previous year sales, then divides by previous year sales to get growth percentage. CALCULATE changes context, and MAX gets the current year.