How to concatenate strings in EazyBI?

Jm Ll June 28, 2018

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?

2 answers

0 votes
Josep Lluis Perez November 11, 2020

Anyone knows about doing that? @Jm Ll 

Sir Mārtiņš Vanags
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 11, 2020

Hi,

Try this formula when creating a new calculated measure:

 

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

 

Martins / eazyBI support

 

example.png

Like Josep Lluis Perez likes this
Josep Lluis Perez November 11, 2020

Thank you!! It's working

 

Josep

0 votes
Scott Simmerman September 12, 2018

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events