Forum Discussion

Cervo114's avatar
Cervo114
Frequent Visitor
2 years ago

In Report Builder Concatenate multiple records in one row

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

report builder

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Cervo114
      Frequent Visitor
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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.