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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Rosalind90
Frequent Visitor

How to distill results down to single instances in a new table

This is a follow up to this solved question 

I originally asked how to return a result based on a step-by-step process. I got a great answer from @lbendlin, and have a new question:

I now need to take the results from "Group Status", and only have them displayed once, either in a new column, or having the column be simplified somehow. I have a feeling it involves keeping the self-referential aspect for "Groups" and maybe list.distinct or list.single, but I'm not sure where to go with that.

Here is the data I'm working with now (opens in a sheets file) 

Thanks!

 

1 ACCEPTED SOLUTION

you can either group by "Groups" and "Group Status"  in Power Query , or you can opt to do that all in Power BI which will automatically group these for you.

View solution in original post

4 REPLIES 4
Rosalind90
Frequent Visitor

That works! Thanks again.

lbendlin
Super User
Super User

If you group by the Group Status field you need to indicate what to do with the other data.

It may be best to have this be a second query, so the results can go to another table. That way all the data can be kept from the initial query. I hope that simplifies things. I've included a table of what I'm hoping to achieve in this result:

 

redMeasure coffee beans
blueGrind coffee beans
greenMeasure coffee beans
yellow Add grounds to filter

you can either group by "Groups" and "Group Status"  in Power Query , or you can opt to do that all in Power BI which will automatically group these for you.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors