Forum Discussion
Antoinette123
Helper I
Helper IAggregating dates into months in pivot tables
Hi everyone! I have a table with some data regarding to different dates (days by days). I need to create a pivot table (power query) and use month (not days) as a filter in it. Just like in the attached picture. How can I do that?
You could select the column and in the "add column" tab in the ribbon go to the dates options and add a column to extract the month from the date. From there you could use the pivot operation as described in the link below:
1 Reply
- miguel
Community Admin
You could select the column and in the "add column" tab in the ribbon go to the dates options and add a column to extract the month from the date. From there you could use the pivot operation as described in the link below: