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 attac...
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:
miguel
Community Admin
Community AdminYou 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: