From the course: Power BI Data Methods (2019)

Unlock the full course today

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

Merging fields

Merging fields

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Merging fields

“

- Merging columns works the opposite way of splitting them. It takes two or more columns and combines them into a single field in a functionality similar to concatenation. We see here, we take a five-digit zip code and combine it with the four-digit delivery code for the zip code into a final zip code. It uses a dash to separate the fields. In order for the merge functionality to work, the merge fields must have the same data type. In our US Census Power BI file, we go to the GEOID to county mapping, the web connection, to show how the merging functionality works. We want to combine the state code and the county code into a single field called GEOID. First we need to make sure that both these data types are set to the same for both the fields. They're currently both numbers. We want to actually use text data types instead to preserve the leading zeroes. We go ahead and select "Text" and replace the current step so…

Contents