topic Translate values from rows into a single record value in DAX Commands and Tips

Translate values from rows into a single record value

brief001 — Tue, 04 Jan 2022 13:15:51 GMT

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')

Re: Translate values from rows into a single record value

amitchandak — Tue, 04 Jan 2022 13:20:19 GMT

brief001 , Create a measure using concatenatex

concatenatex(table, table[Activity])

and use it with order_id

Re: Translate values from rows into a single record value

smpa01 — Tue, 04 Jan 2022 13:31:23 GMT

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]))

Re: Translate values from rows into a single record value

brief001 — Tue, 04 Jan 2022 13:37:38 GMT

Thank you!! Solved with:

Tabel_New = SUMMARIZE(Tabel,

Tabel[Order_ID] ,

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

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