Forum Discussion

karimk's avatar
karimk
Icon for Helper III rankHelper III
4 years ago
Solved

M 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 ...
Need Help
  • HotChilli's avatar
    HotChilli
    4 years ago

    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's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

Will depend on the size of the data I suppose.  You could check to see if query folding is taking place.

Also you could also investigate the buffer functions to see if PQ can read files once instead of multiple times.