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?

     

     

     

Wyn Hopkins's avatar
Wyn Hopkins
MVP
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?

 

 

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 07, 2019

Wyn Hopkins 

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

Resources