Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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/202...
  • vaibhavkale570's avatar
    3 years ago

    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