Total budgets by year and family, how to divide monthly to compare with billing?

[Syndicate_Admin]

I have a table with the annual budgets by product family, I would like to create a table from this with the monthly budgets per family to be able to compare monthly billing with budgets, in a normal and accumulated way.

This is the original table:

Family	Year	Budget
Family A	2022	18000
Family B	2022	23000
Family C	2022	12000
Family A	2021	12000
Family B	2021	16000
Family C	2021	6000

And here's the table I want to get:

Family	Month-Year	Budget
Family A	01-2022	1500
Family A	02-2022	1500
Family A	03-2022	1500
Family A	04-2022	1500
Family A	05-2022	1500
Family A	06-2022	1500
Family A	07-2022	1500
Family A	08-2022	1500
Family A	09-2022	1500
Family A	10-2022	1500
Family A	11-2022	1500
Family A	12-2022	1500
Family B	01-2022	1916,66
Family B	02-2022	1916,66
Family B	03-2022	1916,66
Family B	04-2022	1916,66
Family B	05-2022	1916,66
Family B	06-2022	1916,66
Family B	07-2022	1916,66
Family B	08-2022	1916,66
Family B	09-2022	1916,66
Family B	10-2022	1916,66
Family B	11-2022	1916,66
Family B	12-2022	1916,66
Family C	01-2022	1000
Family C	02-2022	1000
Family C	03-2022	1000
Family C	04-2022	1000
Family C	05-2022	1000
Family C	06-2022	1000
Family C	07-2022	1000
Family C	08-2022	1000
Family C	09-2022	1000
Family C	10-2022	1000
Family C	11-2022	1000
Family C	12-2022	1000
Family A	01-2021	1000
Family A	02-2021	1000
Family A	03-2021	1000
Family A	04-2021	1000
Family A	05-2021	1000
Family A	06-2021	1000
Family A	07-2021	1000
Family A	08-2021	1000
Family A	09-2021	1000
Family A	10-2021	1000
Family A	11-2021	1000
Family A	12-2021	1000
Family B	01-2021	1300,33
Family B	02-2021	1300,33
Family B	03-2021	1300,33
Family B	04-2021	1300,33
Family B	05-2021	1300,33
Family B	06-2021	1300,33
Family B	07-2021	1300,33
Family B	08-2021	1300,33
Family B	09-2021	1300,33
Family B	10-2021	1300,33
Family B	11-2021	1300,33
Family B	12-2021	1300,33
Family C	01-2021	500
Family C	02-2021	500
Family C	03-2021	500
Family C	04-2021	500
Family C	05-2021	500
Family C	06-2021	500
Family C	07-2021	500
Family C	08-2021	500
Family C	09-2021	500
Family C	10-2021	500
Family C	11-2021	500
Family C	12-2021	500

How could I get this table?

[Syndicate_Admin · Accepted solution]

Hello, I would recommend you to modify the table, add the month and monthly budget as well.

1. Modify the table

2. Add month column with the following formula

each List.Generate(() => 12, each _ > 0, each _ - 1)

3. Add a Monthly Budget column

[Syndicate_Admin]

Thank you very much, this was what I wanted.
Best regards