How to concatenate two strings in calculated field?

Hi,

how can I concatenate two strings in calculated field? I just need to add a special prefix to an existing string field. Your documentation is silent about this.

Thanks,
Radek

[Measures].[String 1 example] || " " || [Measures].[String 2 example]

You use || for appending, and can add any delimiter you choose. In the example above I used a space as the delimiter.

Hope this helps.

– Malik Graves-Pryor

2 Likes

Hi,

Please try the approach @malikgp shared.

Thanks!
Best regards,