Forum Discussion
Group By
I am fairly new to Power Query but am learning quickly. I have a data set of lots bidders that shows the ID# for each proposal, ID# for each bidder, and then each bid. My goal is to pull the lowest b...
Hard to be specific without sample data, but you could add an aggregation to the Table.Group function which outputs the bidder ID. You would do this in the Advanced Editor. Something like {"Bidder ID", each [Bidder ID #]{0}, type text}