Group items by month number

[Anonymous]

Hello,

I have the following table in Power Query and i am trying to group the "Sold items" by month number. Any help is much appreciated!

Sold items	Date
126	01/06/2022
108	27/06/2022
87	07/09/2022
69	11/08/2022
67	08/10/2022
84	20/09/2022
57	27/09/2022
46	10/11/2022
47	02/09/2022
53	09/10/2022
81	15/10/2022
118	17/09/2022
142	06/10/2022
165	23/11/2022
167	02/12/2022

Expected results in Power Query:

Sold items	Month number
234	6
69	8
393	9
343	10
211	11
167	12

[vaibhavkale570 · Accepted solution]

follow below steps

1.add new column for month no

add column>date>month>month

2.selec and group by month no column

transform>group by