CONCATENATE to columns together in Power BI

Power Query
1

Good day,

Can anyone help me find a way to create a column that concatenates two fields from a table? One of the fields is a text field, and then the other one is a value field.

Looking forward to your suggestions!

Thanks in advance!

2

This is quite easy stuff. I think you’ll get the hang of this quite quickly.

You can try the following:

  1. In the Edit Query menu, select ‘Add Column’ and then select “Add Custom Column”. Put in the name of your new column and then select the columns from the right-hand side menu. And don’t forget to place an “&” between them.

OR

  1. With DAX or Power Query, just use “&” to concatenate two fields:

Column = Table1[Text] & Table1[Number]

I recommend working through some of the beginner courses at Enterprise DNA Online here. You’ll learn everything you need to get started in Power BI and answer many of these fundamental questions.

Good luck!

Sam

3

Thanks to the contributors of this post. Due to the length by which this post has been active, we are tagging it as Solved. For further questions related to this post, please make a new thread.