Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Concatenate string from relating rows

Dear All, I have a use case where I would like to create description strings for a travel company about road trips.   Summary table: Road trip ID Description string Travel1 Milano-Geneva-...
Need Help
  • camargos88's avatar
    camargos88
    5 years ago

    Anonymous ,

     

    Check this new code:

    Summary = 
    ADDCOLUMNS(
        VALUES('Table'[Road trip ID]), 
        "Desc", CONCATENATEX(FILTER('Table', 'Table'[Road trip ID] = EARLIER('Table'[Road trip ID])), 'Table'[Stop place], "-", 'Table'[Stop index], ASC) 
    )

     

    Concatenex has a sort by parameter.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  Anonymous ,

 

Here are the steps you can follow：

1. Create calculcated table.

Row data table =
SUMMARIZE(
    'Table',
    'Table'[Road trip ID],
    "Description string",CONCATENATEX(FILTER('Table','Table'[Stop index]<='Table'[Stop index]),'Table'[Stop place],"-"))

2.  Result.

You can downloaded PBIX file from here.

 

Best Regards,

Liu Yang

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