Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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 |
---|---|
94 | |
79 | |
76 | |
65 | |
60 |
User | Count |
---|---|
108 | |
101 | |
77 | |
63 | |
61 |