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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vanessza93
New Member

Grouping the Values with a comma by >each equal< Category >only for< each equal name

Hello guys
can someone help me with another problem I got here? 
 
a1.png
Basicaly have this table and want to output it like this
 
Grouping the Values with a comma by >each equal< Category >only for< each equal namea2.png
1 ACCEPTED SOLUTION
ray_ux
Memorable Member
Memorable Member

@vanessza93 

Here is an approach that you can make it work:

1] Group By on the first two columns
2] the remaining column is set to all rows

 

Now the data is segregated, you would need to Sort( distinct())
After you should see a list of values, make sure they are all text (change data type to text)
Then Text.Combine( list, ", " )

To wrap it up:

GroupBy Name, Category with All Rows

View solution in original post

1 REPLY 1
ray_ux
Memorable Member
Memorable Member

@vanessza93 

Here is an approach that you can make it work:

1] Group By on the first two columns
2] the remaining column is set to all rows

 

Now the data is segregated, you would need to Sort( distinct())
After you should see a list of values, make sure they are all text (change data type to text)
Then Text.Combine( list, ", " )

To wrap it up:

GroupBy Name, Category with All Rows

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.