Scribd
Upload
97 views7 pages

Cleaning Text Data in Power BI

Power Query in Power BI can be used to clean and transform text data. This includes functions like Trim and Clean to remove whitespace and special characters, and formatting options to standardize capitalization. Text can also be split or combined - such as splitting an address column into multiple columns or combining first and last names. The document provides examples of text cleaning and transformation techniques in Power Query to prepare data for analysis.

Uploaded by

Komi David ABOTSITSE
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
97 views7 pages

Cleaning Text Data in Power BI

Power Query in Power BI can be used to clean and transform text data. This includes functions like Trim and Clean to remove whitespace and special characters, and formatting options to standardize capitalization. Text can also be split or combined - such as splitting an address column into multiple columns or combining first and last names. The document provides examples of text cleaning and transformation techniques in Power Query to prepare data for analysis.

Uploaded by

Komi David ABOTSITSE
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 7

Transforming text in

Power Query
D ATA P R E PA R AT I O N I N P O W E R B I

Maarten Van den Broeck


Content Developer at DataCamp
What is clean text data?
Free from typos Yeelow -> Yellow

Consistently forma ed
Data points are consistently represented

Uniform capitalization

No leading or trailing whitespace

No punctuation(!) or control characters


(\n, \r, etc.)

Ideally, each column will only store one


piece of information
Columns are split or merged to achieve
this

DATA PREPARATION IN POWER BI


How to clean text data?
Accessed from the Transform ribbon

Use the Format option to change the capitalization and access Trim and Clean

Trim & Clean should be applied to all text columns


Trim - removes trailing and leading whitespace

Clean - removes control characters (new line, carriage return, etc.)

DATA PREPARATION IN POWER BI


Splitting and combining columns
Each column in your dataset should
represent one piece of information
It is sometimes necessary to split or
combine several columns

When one column contains many pieces of


information -> Split
Address -> Building, Street, City, Country

When two or more columns can be


combined to represent one piece of
information -> Combine
First Name, Last Name -> Full Name

DATA PREPARATION IN POWER BI


Let's practice!
D ATA P R E PA R AT I O N I N P O W E R B I
Text transformation
D ATA P R E PA R AT I O N I N P O W E R B I

Maarten Van den Broeck


Content Developer at DataCamp
Let's practice!
D ATA P R E PA R AT I O N I N P O W E R B I

You might also like