Forum Discussion

cottrera's avatar
cottrera
Post 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]

danielescalante's avatar
danielescalante
New Member
2 years ago

ésto me funciono realmente, Muchas Gracias