Forum Discussion

CostaBella's avatar
CostaBella
Frequent Visitor
4 years ago

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...
Need Help
danishefa's avatar
danishefa
Frequent Visitor
4 years ago

Can you please select the columns ID# proposal and also ID# bider and then select group by

  • CostaBella's avatar
    CostaBella
    Frequent Visitor
    4 years ago

    Yea I tried that, but it still has all the bids for each proposal and bidder. I want it to only show the lowest bid while still mainting the ID#s for proposals and bidders.

     

    Pro ID        Bidder ID             Bid Amount