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.

camargos88's avatar
camargos88
Community Champion
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

    Thank you very much!