Forum Discussion

Bailey100's avatar
Bailey100
Brass Contributor
Jun 07, 2019
Solved

Showing which month is the busiest in excel?

Hi,   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 m...
excel
Excel Online
Formulas and Functions
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Jun 07, 2019

    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's avatar
Bailey100
Brass Contributor
Jun 07, 2019

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,

Bailey100

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jun 07, 2019

Bailey100 

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

Resources