How to add rows by incrementing a date monthly for 12 months

[Anonymous]

Good afternoon everyone and happy new year.

I would like to kindly ask for your support for the following purpose: I have to create a new column in which I can scroll the date (from a start date and an end date in two specific columns of the row) monthly. This is to be done for each row, cloning the content present in the other columns.
Here is an example of what it looks like now:

ID	Issue Date	Due Date	Amount
X1	01/03/2022	01/03/2023	€ 1.000
X2	27/09/2022	27/09/2023	€ 1.200
X3	12/04/2021	12/04/2022	€ 768

and how I would like to populate the new column 'MonthlyDate' scrolling monthly from the issue date (in the first case, 01/03/22) per 12 months (due date minus 1):

ID	Issue Date	Due Date	Amount	MonthlyDate
X1	01/03/2022	01/03/2023	€ 1.000	01/03/2022
X1	01/03/2022	01/03/2023	€ 1.000	01/04/2022
X1	01/03/2022	01/03/2023	€ 1.000	01/05/2022
X1	01/03/2022	01/03/2023	€ 1.000	01/06/2022
X1	01/03/2022	01/03/2023	€ 1.000	01/07/2022
X1	01/03/2022	01/03/2023	€ 1.000	01/08/2022
X1	01/03/2022	01/03/2023	€ 1.000	01/09/2022
X1	01/03/2022	01/03/2023	€ 1.000	01/10/2022
X1	01/03/2022	01/03/2023	€ 1.000	01/11/2022
X1	01/03/2022	01/03/2023	€ 1.000	01/12/2022
X1	01/03/2022	01/03/2023	€ 1.000	01/01/2023
X1	01/03/2022	01/03/2023	€ 1.000	01/02/2023
X2	27/09/2022	27/09/2023	€ 1.200	27/09/2022
X2	27/09/2022	27/09/2023	€ 1.200	27/10/2022
X2	27/09/2022	27/09/2023	€ 1.200	27/11/2022
X2	27/09/2022	27/09/2023	€ 1.200	27/12/2022
X2	27/09/2022	27/09/2023	€ 1.200	27/01/2023
X2	27/09/2022	27/09/2023	€ 1.200	27/02/2023
X2	27/09/2022	27/09/2023	€ 1.200	27/03/2023
X2	27/09/2022	27/09/2023	€ 1.200	27/04/2023
X2	27/09/2022	27/09/2023	€ 1.200	27/05/2023
X2	27/09/2022	27/09/2023	€ 1.200	27/06/2023
X2	27/09/2022	27/09/2023	€ 1.200	27/07/2023
X2	27/09/2022	27/09/2023	€ 1.200	27/08/2023
…	..	…	…	…

the coloured lines are for illustrative purposes only.

Then, I would like to create a new column "Earned Premium" as the following Excel formula:

(please note that in italian the formula "SE" is equal to "IF").

Many thanks for your support!

Cheers

[amitchandak]

@Anonymous , based on what I got, see if this can help

https://amitchandak.medium.com/power-bi-power-query-vs-dax-months-between-range-df019cec823b

[Anonymous]

Hi @amitchandak, thanks for the link but it seems far from what I am looking for...

In the community I had found this solution with 'NumberFrom' very similar to what I need but it returns daily dates and not monthly. I would need to achieve a similar result by adding 11 rows to each row I already have and not 30:
How to add rows for dates between start and end dates in Power BI date range data | NateChamberlain....

Could you please help me?

Mnay thanks.

[amitchandak]

@Anonymous , I think, my solution is monthly. You need startdate of the month not end of month as in my case

Date.StartOfMonth in power query in place of EndOfMonth

and Eomonth([Date],-1) +1 to get the start of month in dax.