The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I'm working in Power BI and trying to combine similar rows while putting the differences in the same cell.
Here's an example of my current data:
File # | Assigned Staff | Project Name |
1 | John Doe | Space March |
1 | Jane Smith | Space March |
2 | Dave Williams | File Sharing |
Here's what I'm aiming to do:
File # | Assigned Staff | Project Name |
1 | John Doe/Jane Smith | Space March |
2 | Dave Williams | File Sharing |
Solved! Go to Solution.
Hi @M_Capps ,
To combine similar rows in Power BI where the File # and Project Name are the same, and you want to merge the Assigned Staff values into a single cell separated by a slash, you can do this in Power Query. First, go to the Power Query Editor. Use the Group By feature, grouping by both File # and Project Name. For the operation, select "All Rows" so that you can access the individual rows grouped together. Then, add a custom column that merges the Assigned Staff values using Text.Combine.
Here's the custom column formula you can use:
Text.Combine([Assigned Staff], "/")
After that, remove the original nested Assigned Staff column and keep the new column with combined values. This will give you the desired output where names are joined like John Doe/Jane Smith under a single row for the same file and project.
Best regards,
That worked brilliantly. Thanks.
Hi @M_Capps ,
To combine similar rows in Power BI where the File # and Project Name are the same, and you want to merge the Assigned Staff values into a single cell separated by a slash, you can do this in Power Query. First, go to the Power Query Editor. Use the Group By feature, grouping by both File # and Project Name. For the operation, select "All Rows" so that you can access the individual rows grouped together. Then, add a custom column that merges the Assigned Staff values using Text.Combine.
Here's the custom column formula you can use:
Text.Combine([Assigned Staff], "/")
After that, remove the original nested Assigned Staff column and keep the new column with combined values. This will give you the desired output where names are joined like John Doe/Jane Smith under a single row for the same file and project.
Best regards,