Trim and clean text in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the TRIM function do in Power BI?

TRIM removes all extra spaces from text except for single spaces between words. It helps clean up text data by removing leading, trailing, and multiple spaces.

beginner

How does the CLEAN function help with text data?

CLEAN removes non-printable characters from text, such as line breaks or special control characters, making the text easier to work with in reports.

intermediate

Write a simple DAX expression to trim and clean a column named 'CustomerName'.

CleanTrimName = TRIM(CLEAN('Table'[CustomerName])) This removes extra spaces and non-printable characters from the CustomerName column.

beginner

Why is it important to clean and trim text data before analysis?

Cleaning and trimming text ensures consistent data, avoids errors in matching or filtering, and improves the accuracy of reports and visuals.

intermediate

Can TRIM remove non-breaking spaces or special invisible characters?

No, TRIM only removes regular spaces. To remove non-breaking spaces, use SUBSTITUTE or REPLACE functions. CLEAN removes non-printable characters.

What does the TRIM function remove from text in Power BI?

A All spaces including single spaces

B Non-printable characters

C Extra spaces except single spaces between words

D Numbers and symbols

TRIM removes extra spaces but keeps single spaces between words.

Which function removes non-printable characters like line breaks?

A CLEAN

B TRIM

C UPPER

D LOWER

CLEAN removes non-printable characters from text.

What is the correct order to clean and trim text in DAX?

A LOWER(CLEAN(text))

B CLEAN(TRIM(text))

C UPPER(TRIM(text))

D TRIM(CLEAN(text))

First CLEAN removes non-printable characters, then TRIM removes extra spaces.

Why should you clean and trim text data before analysis?

A To improve data consistency and accuracy

B To make text longer

C To add special characters

D To change text to numbers

Cleaning and trimming improves data quality and report accuracy.

Can TRIM remove non-breaking spaces?

A Yes, always

B No, TRIM only removes regular spaces

C Only if combined with CLEAN

D Only in Power Query

TRIM does not remove non-breaking spaces; other methods are needed.

Explain how you would clean and trim a text column in Power BI using DAX.

Think about the order of applying CLEAN and TRIM.

Why is trimming and cleaning text data important before creating reports or dashboards?

Consider how messy text can affect your analysis.