The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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....
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |