Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
2,111
Views
Topic starter
Does anyone know if it's possible to group dates into 7 day buckets from Monday through Sunday in PQ? I've used pivot table grouping to achieve this but once you group the fields then you can't use custom formatting, i.e. list only the month and day ranges without the year (1/6-1/12, 1/13-1/19, etc.); this is especially useful when doing charts in order to limit the axis label length.
Thanks,
Tyler
Posted : 03/01/2020 5:09 pm
Hi Tyler,
Try adding a Week of Year column, each day in a specific week will have the same week number. You can also choose the first day of the week.
https://docs.microsoft.com/en-us/powerquery-m/date-weekofyear
Posted : 04/01/2020 2:02 am