Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyMax Date
Hi good day, can anyone help me on my PQ, I have a table with column Scope and Date, I required only to show the max date per scope. DESIRED OUTPUT Thank you
Hi,
One of ways is to use Table.Group M function.
Table.Group - PowerQuery M | Microsoft Learn
let Source = source, #"Grouped Rows" = Table.Group(Source, {"scope"}, {{"date", each List.Max([date]), type nullable date}}) in #"Grouped Rows"Hi AllanBerces
You can do a GroupBy in the query editor
Moving forward, please make it a habit to post a sample data we can easily copy and paste to Excel - not an image.
Jihwan_Kim
Super User
Super UserHi,
One of ways is to use Table.Group M function.
Table.Group - PowerQuery M | Microsoft Learn
let
Source = source,
#"Grouped Rows" = Table.Group(Source, {"scope"}, {{"date", each List.Max([date]), type nullable date}})
in
#"Grouped Rows"