Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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....
@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!
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....
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |