How to group duplicate dates?

[Kushagra15]

Hi

i wanted to group these duplicate dates into one field, the way i want this to happen is, if i group a specific date then all the corresponding fields must also be either summed or averaged.

every date has 24 rows for 24 hours that needs to be grouped in 1 date and other column, example count of bike shares must be summed within a single date, similarly other fields should also be averaged or summed.

i was trying to use datesinbetween function for moving average but it won't allow me as there are duplicates in date field.

thanks in advance.

[Kushagra15]

thanks a lot it worked 🙂

[amitchandak · Accepted solution]

@Kushagra15 , In power query first create a new column

Date  only= DateTime.Date([Date])

Then use group by https://docs.microsoft.com/en-us/power-query/group-by