Forum Discussion

brief001's avatar
brief001
Icon for Helper II rankHelper II
4 years ago
Solved

Translate values from rows into a single record value

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 show...
  • amitchandak's avatar
    amitchandak
    4 years ago

    brief001 , Create a measure using concatenatex

    concatenatex(table, table[Activity])

     

    and use it with order_id

  • brief001's avatar
    brief001
    4 years ago

    Thank you!! Solved with:

    Tabel_New = SUMMARIZE(Tabel, 
        Tabel[Order_ID] ,
        "Activity_Summary" , concatenatex(Tabel, Tabel[Activity]) ,
        "Duration_Total" , SUM(Tabel[Duration] ))

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

brief001 , Create a measure using concatenatex

concatenatex(table, table[Activity])

 

and use it with order_id

brief001's avatar
brief001
Icon for Helper II rankHelper II
4 years ago

Thank you!! Solved with:

Tabel_New = SUMMARIZE(Tabel, 
    Tabel[Order_ID] ,
    "Activity_Summary" , concatenatex(Tabel, Tabel[Activity]) ,
    "Duration_Total" , SUM(Tabel[Duration] ))