Forum Discussion
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...
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.