Concatenate with some special charcaters

[jimmyg706]

Hi Folks

Im struggling with this

Here is a snapshot of my table whcih Ive simplified

Company	Product
Jumbo	Peanut

I want to concatenate Column 1 and Column 2 so that it shows in a new DAX cacluated column as follows

Jumbo (Peanut)

So a space between the two columns and also add brackets to the value in Coumn 2

Its driving me mad as I cant get it to work

Comments welcome.

Jimmy

[jimmyg706]

@DataVitalizer     I realy didnt know you could do that. I could do this oin excel standing on my head. DAX was drving me mad.

A big thannks for this. I love this community "

[DataVitalizer · Accepted solution]

Hi @jimmyg706 

You can simply write this piece of code

= Your_Table[Company] & " (" & Your_Table[Product] & ")"

Did it work ? 👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge