How to Use the Power BI DAX function CONCATENATE

What is the CONCATENATE function?

The CONCATENATE function in DAX is used to join two strings into a single text string. The syntax for this function is:

CONCATENATE(text1, [text2])

Where `text1` is the first text string, and `[text2]` is a second text string. The CONCATENATE function in DAX accepts only two arguments, whereas the Excel CONCATENATE function accepts up to 255 arguments. If more than two text strings need to be combined, the concatenate operator (&) can be used, or nested CONCATENATE functions.

How to use the CONCATENATE function in Power BI

Let's explore how to use the CONCATENATE function in Power BI through a simple example.

Suppose we have a table containing two columns named `First Name` and `Last Name`. If we want to create a new column that combines these two columns into a single `Full Name` column, we can use the CONCATENATE function.

Here's how we can achieve this:

1. Open Power BI and load the data into the report.

2. Go to the `Data` tab and select the table that contains the columns we want to combine.

3. Click on the `New Column` button in the `Modeling` tab.

4. In the formula bar, type the following formula:

Full Name = CONCATENATE(‘First Name’, CONCATENATE(” “,’Last Name’))

5. Press `Enter`, and the new column is created.

In this example, we used the CONCATENATE function to join the `First Name` and `Last Name` columns with a space between them to create the `Full Name` column.

Power BI DAX Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

6-8 Jun 23 (London or Online)
8-10 Aug 23 (London or Online)
24-26 Oct 23 (London or Online)

Contact Us


    Your Name (required)


    Email (required)


    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)