From the course: Power BI Data Methods (2019)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Splitting fields

Splitting fields

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Splitting fields

“

- [Instructor] We can split a field into two or more fields based on a selected delimiter, number of characters or position. Here, we see that we separate the full US zip code that includes both the five-digit zip code and the four-digit delivery code within the zip code into two separate fields. We use the dash as a delimiter, or separator, to split the two fields on. In the Power BI NOAA station list file, go the the query for the stations. Let's rename this query NOAA Stations. We first need to remove the Changed Type step, because we don't have a column to reference. We can see that we have a step-level error message. It says, "'Column2' of the table was not found." Remember, the Power BI initially separated the query into two columns. We changed the query so that Column2 does not exist anymore. We can click on the little X to remove the Changed Type step. We now have all our data in a single column. To split…

Contents