how can i aggregate/combine, multiple row values into a single row field

[glenmclaren]

Hi all, firstly i'm not sure if this can even be done.

i am working with a dataset in direct mode, so i can only create calculated measures via DAX. There is no transformation tab.

in this example, i have 5 rows of data

car	john
car	glen
car	tom
bike	paul
bike	john

what i would like to achieve is this

car	john, glen, tom
bike	paul, john

so any help would be welcome

thanks in advanced

g

[Jihwan_Kim · Accepted solution]

Hi, @glenmclaren 

Please try to write the below for the calculated measure.

Result =

CONCATENATEX('Table', 'Table'[Column2], ", ")

Or, if you want to create a new table, try below.

new table =

SUMMARIZE( 'Table', 'Table'[Column1], "Column2", CONCATENATEX('Table', 'Table'[Column2], ", "))

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

[glenmclaren]

hello, thanks for the response, it is close, but it puts all the agains each record

car	john, glen, tom, paul, john
bike	john, glen, tom, paul, john

how can i make it specific to the relevant records

car	john, glen, tom
bike	paul, john

thanks

[Jihwan_Kim]

Hi, @glenmclaren 

Please check the link down below.

I am not sure what I have missed, but please correct me if I wrongly understood your question.

https://www.dropbox.com/s/dks31vlz4t2ofqz/glenmclaren.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.