cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cottrera
Post Partisan
Post Partisan

Concatenate 3 columns

Hi I wish to use DAX in power bi to concatenate 3 columns. However I would like to place hyphen symbol ( - ) between each concatenated column. Thanks Richard
1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi, Richard. @cottrera 

 

The quickest way to do this is using the ampersand & character. Like this,

 

Column D = [column a] & " - " & [column b] & " - " & [column c]

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi, Richard. @cottrera 

 

The quickest way to do this is using the ampersand & character. Like this,

 

Column D = [column a] & " - " & [column b] & " - " & [column c]

The proposed solution worked well in 2019 and for just three columns but in case anyone stumbles across this now, I would like to point out there is a better way that probably wasn't available in 2019


The DAX "COMBINEVALUES" function joins text using a delimiter.

COMBINEVALUES("-",Column1, Column2, Column2)


and this can be used for many more columns as well

Note that the delimiter cannot be a blank or empty string so if you don't want to join your values with a delimiter, then just use one that will definitely not be in the columns and then substitute it afterwards (e.g. "~" or similar).

SUBSTITUTE(
COMBINEVALUES("~",
Column1,
Column2,
Column3
),
"~",""
)

 

Hi Anonymous, this was pretty **bleep** clever and saved my @ss. Thank you! 

Works perfect thank you for the quick reponse

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors