Forum Discussion
stribor45
Post Prodigy
Post ProdigySelecting Rows by Max Date and something else
I have table where multiple rows with same ID may exist but with different or sometimes same values in Date column. Of course I can group this by ID and select ones with MAX date however since some...
Table.FromRecords( Table.Group(Source, "id", {"recs", (x) => Table.Max(x, {"Date", (w) => - w[Decision column]})})[recs] )
AlienSx
Super User
Super UserTable.Max(table as table, comparisonCriteria as any, optional default as any) as anywrite your own comparisonCriteria