Forum Discussion
Solved
Group value per article by MIN Date
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?
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}})
1 Reply
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}})