Forum Discussion

shaebert's avatar
shaebert
Helper III
3 years ago
Solved

Need Help Grouping and Combining Rows

Hello, I have a table of data that I need help transforming. Below is a before/after example.    Before:   Campaign     Contact URL 1 Joe Smith google.com 1 Joe Smith yahoo.com ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi shaebert ,

    Please try below steps:

    1. below is my test table

    Table:

    2. Please try to create a new table with below dax formula:

    Table2 =
VAR tmp =
    SUMMARIZE ( 'Table', [Campaign], [Contact] )
RETURN
    ADDCOLUMNS ( tmp, "URL", CALCULATE ( CONCATENATEX ( 'Table', [URL] & "," ) ) )

     

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi shaebert ,

Please try below steps:

1. below is my test table

Table:

2. Please try to create a new table with below dax formula:

Table2 =
VAR tmp =
    SUMMARIZE ( 'Table', [Campaign], [Contact] )
RETURN
    ADDCOLUMNS ( tmp, "URL", CALCULATE ( CONCATENATEX ( 'Table', [URL] & "," ) ) )

 

Please refer the attached .pbix file.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.