Concatenate multiple fields into a single one

Questions & Answers
1

We need to concatenate multiple fields into a single one to display in the report.

Example:

  • Field 01 (custom_field 123)
  • Field 02 (custom_field 234)
  • Field 03 (custom_field 567)

Single field with all options displayed.

It must present the value of the field that is not empty.

Captura de Tela 2023-02-10 às 18.41.50
Captura de Tela 2023-02-10 às 18.41.501792×1070 59.3 KB

2

Hi @Grace_Campos ,

Suppose the fields are imported in eazyBI as issue properties, and concatenated values are required for individual issues. In that case, you can define a new calculated measure with the formula below:

Generate(
  Filter(
  {[Measures].[Issue labels],
   [Measures].[Issue T-shirt size],
   [Measures].[Issue assignee]},
   CoalesceEmpty([Measures].CurrentMember, "(none)") <> "(none)"
   ),
   CAST([Measures].CurrentMember as string), ", "
)

Replace the issue properties “Issue labels”, “Issue T-shirt size”, and “Issue assignee” with the issue properties relevant to your use case. See the expected result below:

Screenshot 2023-02-20 at 16.31.59
Screenshot 2023-02-20 at 16.31.591868×1580 296 KB

Review the eazyBI documentation for more details on the used functions - MDX function reference.

Best,
Roberts // support@eazybi.com