https://community.fabric.microsoft.com/t5/Dataflow/Aggregating-dates-into-months-in-pivot-tables/m-p/4104965#M3645 <P>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?</P><P><img /></P><P> </P> Sat, 17 Aug 2024 00:38:41 GMT Antoinette123 2024-08-17T00:38:41Z https://community.fabric.microsoft.com/t5/Dataflow/Aggregating-dates-into-months-in-pivot-tables/m-p/4104965#M3645 <P>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?</P><P><img /></P><P> </P> Sat, 17 Aug 2024 00:38:41 GMT https://community.fabric.microsoft.com/t5/Dataflow/Aggregating-dates-into-months-in-pivot-tables/m-p/4104965#M3645 Antoinette123 2024-08-17T00:38:41Z https://community.fabric.microsoft.com/t5/Dataflow/Aggregating-dates-into-months-in-pivot-tables/m-p/4104994#M3647 <P>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:</P> <P><A href="https://learn.microsoft.com/en-us/power-query/pivot-columns" target="_blank">https://learn.microsoft.com/en-us/power-query/pivot-columns</A></P> Sat, 17 Aug 2024 01:49:47 GMT https://community.fabric.microsoft.com/t5/Dataflow/Aggregating-dates-into-months-in-pivot-tables/m-p/4104994#M3647 miguel 2024-08-17T01:49:47Z