Group value per article by MIN Date

[joshua1990]

Hi community!

I have a table like this

Article	Department	Country	Group	Date
A	A1	A1A	A1AA	01.01.2023

Since there are multiple values for the same Article I would like to get only the first one.

How would you do that?

Using Group by? If so, how?

[Greg_Deckler · Accepted solution]

@joshua1990 Like this:

This is the M code generated:

#"Grouped Rows" = Table.Group(#"Changed Type", {"Article", "Department", "Country", "Group"}, {{"Date", each List.Min([Date]), type nullable date}})