Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
I need to merge names in a single row and I have been having trouble getting this to work. I would like to do this without using DAX and to have it in query but I am open to a DAX solution as well.
I have a column which lists three different machine names. I need to group two of the machines together.
Machine001
Machine002
Machine003
I would like a column to have
Machine001 & Machine003
Machine002
I've tried various other similar solutions, but nothing is giving the expected result, or they just are not fit for my purpose.
Can anyone help me with this?
Thanks!
Solved! Go to Solution.
Hi @Locco ,
Assume you have grouped the machines.
First add an index column to the table.
Then select the index column and use pivot feature.
At last, merge the selected columns(under Add column tag) and delete unneeded columns.
Best Regards,
Jay
Hi @Locco ,
Assume you have grouped the machines.
First add an index column to the table.
Then select the index column and use pivot feature.
At last, merge the selected columns(under Add column tag) and delete unneeded columns.
Best Regards,
Jay
@Locco what is the logic to combining machine 1 and machine 3?
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
The machines have a combined waste limit. So both machines together cannot exceed X amount of waste. I have no real way of splitting up the waste limit because it's not equally divided between the machines. If I group the machines on this table then their waste is combined and I can compare that against their limit. I have a seperate table with the waste limits and that table has the machines grouped. I figured the easiest option was to group the machines on this table and create a relationship between the two tables.
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
88 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
140 | |
109 | |
68 | |
55 |