Text.Combine – Power Query M Function

The Text.Combine function in Power Query’s M language is used to combine multiple text values into a single text value, optionally separated by a specified delimiter.

Let’s get stated-

Download the sample Dataset from below link-

• Global Super Store Dataset

Requirement-

How to combine multiple text column values  such as – Country, State & City values into one column.

Follow the steps below-

Step-1: Go to the Home Tab of Power BI Desktop and Open Power Query Editor  window by selecting “Transform data” option.

Step-2: In the Queries pane,  select the “Orders” table.

Step-3: In the Home tab, click on “Add Column”  and choose “Custom Column”.

Step-4: In the “Custom Column” dialog box, provide a name for the new column, exp- “Combine”.

Step-5: In the “Custom column formula” box, enter the following expression, and click on “OK” to create the new column.

Text.Combine({[Country], [State], [City]}, ", ")

After applying the changes, you will see a new column named “Combine” in the table, which contains the combined text value of the “Country”, “State”, and “City” columns, separated by commas.

How to combine Text and Number values in Power Query?

You can not directly combine the Text and Number datatype values together using Text.Combine function.

For that you have to use Text.From function which will convert the Sales value to text format.

Text.Combine({[Product Name], Text.From([Sales])}, " - ")

Hope you enjoyed the post. Refer more M functions Tutorials