I have a Power Query from a table. As I am still learning about what Power Query can do I am struggling with Grouping.
What I am trying to do is:
Group by Customer, by level 1, show the earliest date requested for all categories (in this case 2), lastest date updated by level 1, total quantity received by level 1.
If I can get help with putting together this bit, I will be able to work out everything else I need to do with this Power Query table.
I have attached a file containing test data.
I appreciate any help you can give me,