Removing duplicates in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to remove duplicate rows from the table.

Power BI

DistinctTable = DISTINCT([1])

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

ASUMMARIZE

BFILTER

CSales

DVALUES

Attempts:

3 left

💡 Hint

Common Mistakes

Using a function like SUMMARIZE instead of a table name.

Passing a column name instead of a table.

The DISTINCT function removes duplicate rows from the specified table. Here, we use the table name Sales as input.

2fill in blank

medium

Complete the code to create a table with unique CustomerIDs from Sales.

Power BI

UniqueCustomers = VALUES([1][CustomerID])

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

AProducts

BOrders

CCustomers

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using a table that does not have the CustomerID column.

Using DISTINCT instead of VALUES (DISTINCT requires a table expression, not a column).

The VALUES function returns unique values from the specified column. Here, we want unique CustomerIDs from the Sales table.

3fill in blank

hard

Fix the error in the code to remove duplicates from the Sales table.

Power BI

CleanSales = DISTINCT([1])

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

ASales

BSUMMARIZE(Sales, Sales[CustomerID])

CSales[Amount]

DFILTER(Sales, Sales[Amount] > 0)

Attempts:

3 left

💡 Hint

Common Mistakes

Passing a column like Sales[Amount] instead of the whole table.

Using functions inside DISTINCT that return tables but are not needed.

DISTINCT requires a table as input. Using Sales (the table) is correct. Passing a column causes an error; other options use unnecessary table expressions.

4fill in blank

hard

Fill both blanks to create a table with unique CustomerIDs from Sales.

Power BI

UniqueCombos = SUMMARIZE([1], [2])

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

ASales

BSales[CustomerID]

CSales[ProductID]

DProducts

Attempts:

3 left

💡 Hint

Common Mistakes

Using a different table than Sales.

Using a column from a different table.

The SUMMARIZE function groups the Sales table by Sales[CustomerID] to get unique CustomerIDs.

5fill in blank

hard

Fill all three blanks to create a table with unique CustomerID and ProductID combinations using SUMMARIZE.

Power BI

UniqueCombos = SUMMARIZE([1], [2], [3])

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

ASales

BSales[CustomerID]

CSales[ProductID]

DCustomers

Attempts:

3 left

💡 Hint

Common Mistakes

Using columns from different tables.

Using a table other than Sales.

SUMMARIZE groups the Sales table by CustomerID and ProductID columns to remove duplicates of these combinations.