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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors