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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
ERichard
New Member

Grouping Values in New Columns based on Other Column

I have an extract of Learning Assignments, listed by emails.

This is an example of what the data looks like:

ERichard_0-1742822790706.png

I'm trying to group the data by the email, and have an individual column for the learning assigned, but not by the value - just by the count of learning assignments, and in no particular order:

ERichard_1-1742822873195.png

Thanks for your help!

1 ACCEPTED SOLUTION
SundarRaj
Solution Supplier
Solution Supplier

Hi @ERichard, here's a solution you could use to solve your query. Take a look. I'll leave the images of the code, source table and output below. Thanks

SundarRaj_2-1742825193218.png

SundarRaj_3-1742825214192.png

SundarRaj_4-1742825236094.png

 

 

 

 

 

 

 

 

Sundar Rajagopalan

View solution in original post

3 REPLIES 3
v-tsaipranay
Community Support
Community Support

Hi @ERichard ,

I wanted to check if you had the opportunity to review the information provided by @SundarRaj . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.


Thank you.

 

SundarRaj
Solution Supplier
Solution Supplier

Hi @ERichard, here's a solution you could use to solve your query. Take a look. I'll leave the images of the code, source table and output below. Thanks

SundarRaj_2-1742825193218.png

SundarRaj_3-1742825214192.png

SundarRaj_4-1742825236094.png

 

 

 

 

 

 

 

 

Sundar Rajagopalan

Thanks! This worked great!

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

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