In Report Builder Concatenate multiple records in one row

[Cervo114]

Hi, In PowerBi Report Builder, i need to concatenate multiple records in one row, which function can I use? Thank's in advance

[Anonymous]

Hi @Cervo114 ,

Combine more than one field by using concatenation operators and Visual Basic constants. The following expression returns two fields, each on a separate line in the same text box:

=Fields!FirstName.Value & vbCrLf & Fields!LastName.Value

The following link will help you:

Expression examples in Power BI Report Builder - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Cervo114]

My need is to group multiple records in a single row Example: I have some clockings, one at 09:00 am and one at 12:00 am, which are in two different records, my need is to print them in a single line next to each other. I hope I was clear

[Anonymous]

Hi @Cervo114 ,

Please provide the rdl for us.Thank you

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.