How to concatenate strings in EazyBI?

[Jm Ll]

Hi guys,

I have a calculated member in the measures that always returns me a key of type string.

example '123'

I need that in the column where this calculated member is displayed he grabs the key(123) and concatenate with the word "IDEA-", getting like this:

IDEA-123

I can't do  ->   'IDEA-' + [Measures]. [KEY] = IDEA-123

Does anyone know how I can do that?

[Josep Lluis Perez]

Anyone knows about doing that? @Jm Ll 

[Mārtiņš Vanags]

Hi,

Try this formula when creating a new calculated measure:

"IDEA-"||[Measures].[Key]

Martins / eazyBI support

[Josep Lluis Perez]

Thank you!! It's working

Josep

[Scott Simmerman]

I recently ran into this same problem and contacted EazyBI support.  They informed me that the || operator was used for string concatenation.  An odd choice--and undocumented as far as I could tell--but it works.