Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
msciarrino
Helper I
Helper I

Combine Text based on condition from different column

Hello,

 

I am trying to combine text based on the value in a different column. I would prefer to do this in power query but open to all answers.

 

Sample Data

msciarrino_0-1704988654545.png

The last column is what I am trying to achieve.

 

I am trying to combine the text in the Name column based on the value from the Group column.

 

Thank you for your help.

1 ACCEPTED SOLUTION
v-nuoc-msft
Community Support
Community Support

Hi @msciarrino 

 

For your question, here is the method I provided:

 

Here's some dummy data

vnuocmsft_0-1705025656886.png

 

Select "Transform data" to enter the power query

vnuocmsft_1-1705025689043.png

 

Select “Group”, and select “Group By” in the “Transform”

vnuocmsft_2-1705025835593.png

 

Select “Sum” and “Name”

vnuocmsft_4-1705025928020.png

 

Modify the code

vnuocmsft_5-1705025965154.png

 

vnuocmsft_7-1705026020724.png

 

Here is the result, and select “Close & Apply”

vnuocmsft_8-1705026113309.png

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

View solution in original post

1 REPLY 1
v-nuoc-msft
Community Support
Community Support

Hi @msciarrino 

 

For your question, here is the method I provided:

 

Here's some dummy data

vnuocmsft_0-1705025656886.png

 

Select "Transform data" to enter the power query

vnuocmsft_1-1705025689043.png

 

Select “Group”, and select “Group By” in the “Transform”

vnuocmsft_2-1705025835593.png

 

Select “Sum” and “Name”

vnuocmsft_4-1705025928020.png

 

Modify the code

vnuocmsft_5-1705025965154.png

 

vnuocmsft_7-1705026020724.png

 

Here is the result, and select “Close & Apply”

vnuocmsft_8-1705026113309.png

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.