Concatenate rows values

[GilesWalker]

Hi everyone,

I have a table in a databse which has job numbers, template nuber, and comments. I have managed to do a bunch or merges, pivots, and joins to get the table to look like this:

You will notice the bulk of the JobNo is the same, this is becasue whenever a new comment is added it creates a duplicate row. What I want to do is join all the comments in to one sell if the JobNo is the same. Can this be done in Query Editor or am I better off using DAX?

Thanks,

Giles

[Sean]

@GilesWalker Check out this post...

http://community.powerbi.com/t5/Desktop/Help-with-a-table-visualization/m-p/24298#M7829

@ImkeF as you know is the M Expert and she had a great solution there

Hopefully you can make it work in your case!

[Baskar · Accepted solution]

Hey Gileswalker,

 I suggest u go with DAX.

DAX Query :

Concate = CONCATENATEX(Tablename,Comments,"Delimeter whatever u want")

check it and let me know, i will help u if not work....