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

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

3 REPLIES 3
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]

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

Works perfect thank you for the quick reponse

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors