Translate values from rows into a single record value

[brief001]

I have the left table below. And I'm looking for how I can make the right table via a calculated table. In which I am mainly looking for how the values of several rows are 'knotted' together and shown as a summary value. (I am referring to column 'Activity')

[amitchandak · Accepted solution]

@brief001 , Create a measure using concatenatex

concatenatex(table, table[Activity])

and use it with order_id

[smpa01]

@brief001  you can us ethe following two measures

Activity_Summary= CONCATENATEX(VALUES('Table'[Activity]),'Table'[Activity],"",'Table'[Activity],ASC)

Duration_Total= CALCULATE(SUM('Table'[Duration]),ALLEXCEPT('Table','Table'[Order_ID]))

[amitchandak · Accepted solution]

@brief001 , Create a measure using concatenatex

concatenatex(table, table[Activity])

and use it with order_id

[brief001 · Accepted solution]

Thank you!! Solved with:

Tabel_New = SUMMARIZE(Tabel, 

    Tabel[Order_ID] ,

    "Activity_Summary" , concatenatex(Tabel, Tabel[Activity]) ,

    "Duration_Total" , SUM(Tabel[Duration] ))