Forum Discussion
Iterate through all my dataset to select values
- 5 years ago
Hi Anonymous ,
You can use the GROUP BY function in Power Query. Please refer the following screenshot.
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
You can use the GROUP BY function in Power Query. Please refer the following screenshot.
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply and sorry for the late response, I wasn't working on the project yet.
What I needed to perform, was a row operation after the Group By. I had several rows and columns of information for a single incident, so I needed to consolidate all the rows into a single one, based on different column conditions. This might be hard to explain, but here's the documentation that helped me go through, I hope someone might find this helpful.
Thanks!!
Ottmar V