Notifications
Clear all
Power Query
5
Posts
3
Users
0
Reactions
164
Views
Topic starter
Hi,
I have a table of delivery times (formatted as time) by date, I want to group by date (and plant) to create two new columns;
1 - Number of deliveries
2 - Total Time
I manage to do it however the sum of time results in errors, is there something extra I need to do.
Thanks, Lee
Posted : 14/11/2019 6:05 am
Not sure, Lee. Can you share a sample file that contains your query and a mock up of the desired result?
Posted : 14/11/2019 6:43 am
Topic starter
Hi Mynda,
I've attached an example.
Source data table on left, pivot showing required output on right.
The Group By works for average but not total.
Thanks, Lee
Posted : 14/11/2019 9:36 am
Hi Lee,
In the Changed Type step, change from type time to type number. The grouping will work.
Posted : 14/11/2019 11:22 am
Topic starter
Thanks, that worked perfectly!!
Posted : 15/11/2019 4:56 am
