I’m trying to set up a table starting from a table like the following:

`TableName **Jobs**`

| Jobs | Desc | InitDate | EndDate  | MonthlyHours
| A143 | W    | 01/01/24 | 31/03/24 | 4
| B458 | X    | 10/02/24 | 30/04/24 | 6
| R589 | Y    | 01/01/24 | 31/05/24 | 8
| H756 | Z    | 08/03/24 | 30/06/24 | 2

NOTE: date in format dd/mm/yy

Needing a final table like the following (or similar):

`TableName **JobsAggregation**`

| Jobs | Desc | MonthYear | MonthlyHours
| A143 | W    | 01/24     | 4
| A143 | W    | 02/24     | 4
| A143 | W    | 03/24     | 4
| B458 | X    | 02/24     | 6
| B458 | X    | 03/24     | 6
| B458 | X    | 04/24     | 6
| R589 | Y    | 01/24     | 8
| R589 | Y    | 02/24     | 8
| R589 | Y    | 03/24     | 8
| R589 | Y    | 04/24     | 8
| R589 | Y    | 05/24     | 8
| H756 | Z    | 03/24     | 2
| H756 | Z    | 04/24     | 2
| H756 | Z    | 05/24     | 2
| H756 | Z    | 06/24     | 2

I need this set-up to hours per months and using it into a visual object in PowerBI where i can identify how much time i spend per each jobs for every month:

January 12
February 18
March 20
April 16
May 10
June 2

Thanks

I cannot find a solution for this.