Power Query and Random Dates

[msquared99]

OK, how do I using the Advanced Editor in Power Query, make it extract the last date entry in a field? I have about 5,000 ID numbers but have millions of dates. What I want to do is say "for each ID extract the last date they had activity".

This would be the line:

FilteredRows1 = Table.SelectRows(FilteredRows, each [checkDate] > #date(2012, 12, 31))

Thanks.

 

[Phattails]

You can group by ID without expanding the tables and then sort the ids and add an index. Then treat the unexpanded row as a list of tables and use the code from the previous line to do the same thing. Good luck.