Forum Discussion
Max 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.
3 Replies
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.
Hi danextian Jihwan_Kim thank you very much for the reply. it work as i need.
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"
