How to Concatenate with Space in Power BI

In this Power Bi tutorial, we will learn how to concatenate with space in Power BI with examples. In addition, we will also cover the below topics: 

  • How to concatenate two columns with space in Power BI
  • Concatenate two columns with space using Power query

Power BI Concatenate with Space

Let us see how we can concatenate two values with space using concatenate function in Power Bi,

In this example, we will use the below-mentioned Products Table data to concatenate two values with space in Power Bi. Where the Product Name column is of text data type and the Sales column is of Number data type.

Power BI Concatenate with Space
Power BI Concatenate with Space

Open the Power Bi desktop and load the data into the it using get data option, click on the new column, and use the below formula to concatenate two values with space.

 Concatenate with Space = CONCATENATE('Product Set A'[Product Name], CONCATENATE("  ", 'Product Set A'[Sales]))

Where,

  1. Concatenate with Space = New Column Name
  2. Product Set A= Table Name
  3. Product Name, Sales = Existing Column Names

In the below screenshot, the newly created column has displayed the concatenated values with space based on the applied condition:

Power BI Concatenate with Space example
Power BI Concatenate with Space example

This is how to concatenate two values with space using concatenate function in Power Bi.

Concatenate two columns with space in Power BI

Here we will see how to concatenate two columns with space using the query editor in Power BI.

See also  Power BI Group by Column [With Various Examples]

Log in to the Power Bi desktop and load the data into it using the get data option Under the Home tab select the transform data option as highlighted below, it will automatically redirect to the Power Query editor.

power bi concatenate with space
power bi concatenate with space

In the Power query editor, select the columns that you want to concatenate with space, and then Righ clicks on the selected and chooses the merge option as below:

Power bi-concatenate two columns with space
Power bi-concatenate two columns with space

In the Merge column pop-up window, choose the separator as Space and enter the column name and click on the ok button to save your changes.

Power bi-concatenate two columns with space example
Power bi-concatenate two columns with a space example

The Screenshot below displays the concatenated value with space in the newly added column. Click on the Home -> Close and Apply option so that the changes will be reflected in Power BI.

= Table.AddColumn(#"Changed Type", "Merged", each Text.Combine({[Product Name], Text.From([Sales], "en-US")}, " "), type text)
Example of Power bi-concatenate two columns with space
Example of Power bi-concatenate two columns with space

This is how to concatenate two columns with space using the query editor in Power BI.

Also Read: How to Concatenate Text and Number in Power BI

Power Query concatenate two columns with space

Let us see how to concatenate two-column values with space using the power query editor in Power BI.

In this example, we will concatenate two column values with space using the power query editor in Power Bi.

  • Open the Power Bi desktop and load the data into it using the get data option Under the Home tab select the transform data option. It automatically redirects to the Power Query editor.
  • In the Power query editor, select the Add Column-> Add a Custom column as shown below:
  • In the Custom column window, use the below formula to concatenate two values with space, and click on the OK button.
Power Query concatenate two columns with space
Power Query concatenate two columns with space
  • In the below screenshot, you can see that the new custom column has displayed the concatenated value with space.
  • Click on the Home -> Close and Apply option, so that the changes will be reflected on the Power Bi desktop.
= Table.AddColumn(#"Changed Type1", "Custom", each [Product Name]&" "&[Sales])
Power Query concatenate two columns with space example
Power Query concatenate two columns with space example

This is how to concatenate two-column values with space using the power query editor in Power BI.

See also  How to Calculate Percentage of Two Columns in Power BI

In this Power Bi tutorial, we have learned how to concatenate with space in Power BI with examples. In addition, we also covered the below topics: 

  • Power bi-concatenate two columns with space
  • Power Query concatenate two columns with space

You may also like:

>