Forum Discussion

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
7 years ago
Solved

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
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi, Richard. cottrera 

     

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

     

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, Richard. cottrera 

 

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

 

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

Will_'s avatar
Will_
New Member
5 years ago

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