Trim and clean text in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to remove extra spaces from the text column.

Power BI

CleanText = TRIM([1])

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

ATable[BooleanColumn]

BTable[TextColumn]

CTable[DateColumn]

DTable[NumberColumn]

Attempts:

3 left

💡 Hint

Common Mistakes

Using TRIM on a number or date column causes errors.

Forgetting to specify the column name.

The TRIM function removes extra spaces from text. You must apply it to a text column.

2fill in blank

medium

Complete the code to remove non-printable characters from the text.

Power BI

CleanText = CLEAN([1])

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

ATable[TextColumn]

BTable[NumberColumn]

CTable[DateColumn]

DTable[BooleanColumn]

Attempts:

3 left

💡 Hint

Common Mistakes

Applying CLEAN to non-text columns.

Confusing CLEAN with TRIM.

The CLEAN function removes non-printable characters from text columns.

3fill in blank

hard

Fix the error in the code to trim and clean the text column.

Power BI

CleanText = TRIM(CLEAN([1]))

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

ATable[NumberColumn]

BTable[DateColumn]

CTable[TextColumn]

DTable[BooleanColumn]

Attempts:

3 left

💡 Hint

Common Mistakes

Using number or date columns inside TRIM or CLEAN.

Not nesting CLEAN inside TRIM correctly.

Both TRIM and CLEAN require a text column as input. Using a non-text column causes errors.

4fill in blank

hard

Fill both blanks to create a new column that trims and cleans the 'CustomerName' column.

Power BI

CleanName = [1]([2](Table[CustomerName]))

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

ATRIM

BCLEAN

CREMOVE

DSTRIP

Attempts:

3 left

💡 Hint

Common Mistakes

Reversing the order of TRIM and CLEAN.

Using functions that do not exist in Power BI.

The correct order is TRIM outside CLEAN to first remove non-printable characters, then trim spaces.

5fill in blank

hard

Fill all three blanks to create a measure that trims, cleans, and converts the 'ProductCode' column to uppercase.

Power BI

CleanCode = [1]([2]([3](Table[ProductCode])))

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

AUPPER

BTRIM

CCLEAN

DLOWER

Attempts:

3 left

💡 Hint

Common Mistakes

Incorrect function order causing wrong results.

Using LOWER instead of UPPER.

First CLEAN removes non-printable characters, then TRIM removes spaces, finally UPPER converts text to uppercase.