Aggregating dates into months in pivot tables

[Antoinette123]

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?

 

[miguel · Accepted solution]

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:

https://learn.microsoft.com/en-us/power-query/pivot-columns