Forum Discussion
karimk
Helper III
Helper IIIM Formula - Retrieve the max number for a repeating row
Hello, I have a database with multiple rows where each one has a person and some of their info, including an ID. People can show up in more than one row, and their ID can be different. I want ...
You can select the rows with the same name and then get the max ID like this:
List.Max(Table.SelectRows(#"Changed Type", (r) => r[name] = [name] )[ID])#"Changed Type" is the previous step
HotChilli
Community Champion
Community ChampionYou can select the rows with the same name and then get the max ID like this:
List.Max(Table.SelectRows(#"Changed Type",
(r) => r[name] = [name] )[ID])#"Changed Type" is the previous step
