Forum Discussion
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!
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.
4 Replies
- lbendlin
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:
red Measure coffee beans blue Grind coffee beans green Measure coffee beans yellow Add grounds to filter - lbendlin
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.
That works! Thanks again.
