Hello all,
Thank you for reading. I am currently trying to remove rows of a table in powerquery based upon minimum values in a column. Here is an example:
Item Price
Apples 1.99
Apples 2.99
Apples 3.99
Bananas .50
Bananas 1.00
Bananas 2.00
I need the final result to be
Item Price
Apples 1.99
Bananas .50
I think this will require a column with a custom function in powerquery, but am not sure how to go about doing this. I am fairly new to this kind of data processing.
Thank you!
Bookmarks