Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to concatenate strings in EazyBI?


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:


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

Does anyone know how I can do that?

2 answers

Anyone knows about doing that? @Jm Ll 


Try this formula when creating a new calculated measure:




Martins / eazyBI support



Like Josep Lluis Perez likes this

Thank you!! It's working



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
Community showcase
Published in Apps & Integrations

Apps for Confluence you won't want to miss: RSVP for September's Appy Hours

Calling all collaborators and Confluence users! Our Appy Hours event on September 29th features 4 presenters demoing functionality to superpower Confluence. Don't miss learning about these apps i...

122 views 0 9
Read article

Atlassian Community Events