Showing which month is the busiest in excel?




I have a document in which I've got two tables, looking like the one attached. I want to combine the tables together (perhaps i'd use a power query?) and then i want to show which month has more 'actions' in it, to see when i'm busiest. I'm unsure how I would group the actions in months and then show which one was busier - has anyone got any advice please?


Many thanks



5 Replies

Hi @Bailey100 


Power Query will be good then load to Data Model and insert a Pivot Table which can then summarise your dates.


See the attached file...


Once you put a date in a row or column in a Pivot Table you can right click and group by month and year




Have you ever used Power Query before?


What version of Excel are you using?   Excel 2016 ?   Excel 365?




@Bailey100 , if you attach small sample file it'll be easier to demonstrate.

@Wyn Hopkins 

Thank you Wyn, I answered too long and didn't see your post

Hi, @Wyn Hopkins 


Thanks for your response, I have used power query before but only on a basic level. I'm unsure how you've created the pivot table? I'm using excel 2016.


Thanks again,



Select Load to...


Select Add to the Data Model and Only Create a Connection




Insert > Pivot Table > OK


Then set up like this and right click on the dates and choose Group





Group by Day, Month, Year


Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies