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
Einomi's avatar
Einomi
Helper V
4 years ago

I have replicated some of your data

Please try the code below and adjust with the name of your columns

 

let
  Source = Excel.Workbook(File.Contents("/Users/daniel/Desktop/Classeur3.xlsx"), null, true),
  #"Navigation 1" = Source{[Item = "Tableau1", Kind = "Table"]}[Data],
  #"Type de colonne changé" = Table.TransformColumnTypes(#"Navigation 1", {{"Prop ID", Int64.Type}, {"Bider ID", Int64.Type}, {"Bid", Int64.Type}}),
  #"Lignes groupées" = Table.Group(#"Type de colonne changé", {"Prop ID"}, {{"All", each Table.Min( _,"Bid"),type record}})[All],
  Personnalisé =  Table.FromRecords (#"Lignes groupées")
in
  Personnalisé