Forum Discussion
Group items by month number
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 |
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
1 Reply
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