Group by

HI,

You can follow the below steps to achieve the result:

1. Go to Transform Data-->Group By in Power Query Editor

2. Fill the Group By pop up window like this: 

You will see the result as expected.

Before:

After Group By:

Regards,

Ritu

Please Accept the answer as solution if this solves your problem. Happy to help. 😊

It is because Date column datatype is set to String. If you convert it into Date, it will resolve the issue.

If you find this insightful, please give Kudos and Accept it as a solution.