msquared99
Member
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.
This would be the line:
FilteredRows1 = Table.SelectRows(FilteredRows, each [checkDate] > #date(2012, 12, 31))
Thanks.