PowerQuery filter first and last date for each ID

[GormO]

Hi,

I have an extremely long table that I want to sort with PowerQuery. It contains sensitive data so I cannot upload it here, but I have created an example database that mimics it:

From this table I wish to extract the row that has the first and last "License valid from date" for each ProductID. In this example that would give me row 2, 4, 5, 8 and 9. Is there a way to do this in powerQuery?

Cheers
Gorm

 

[shift-del]

Hi Grom

Group the ProductID with Min and Max for the date.