Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
332
Views
Topic starter
hello, I currently have a traditional pivot table that allows me to group dates by any number of days - I am using 14, to show results in 2 week segments. See attached graph and pivot table. What would be the ideal way to handle this in powerpivot since you cannot group the same way. Thank you!
Posted : 02/02/2026 7:28 am
PP alone isn't really suitable for that. You could extend your data table in Excel and add some helper columns that determine the 'two-week buckets', and then load it to the DM via PowerQuery where you need to add some extra information to make it work in PP. The attached workbook is just a very simple example.
Posted : 02/02/2026 7:33 pm