Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
1 year ago
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 o...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    1 year ago

    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}})
Greg_Deckler's avatar
Greg_Deckler
Community Champion
1 year ago

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}})