Duplicated rows based on the number of times the request has been made.

[AmauryC_]

Hello,

My name is Amaury Cabrera, and I would like to request your assistance with the following:

I have a table containing information about recurring requests (both monthly and quarterly, etc.) from the BI department. The table includes the Start Date of the request (when it initially began) and the Recurrence Cancelation Date. If the request has not been completed yet, the Recurrence Cancelation Date field will be empty.

What I need is to create a new table or modify the existing one so that each record is duplicated based on the number of times the request has been made. In other words, if the request was made six times from the start to the end of its validity period, I need the record to be duplicated six times with a new column indicating the date on which each request was made. For example:

ID REQUEST / REQUEST NAME / START DATE / CANCELATION DATE / RECURRENCE

001 / Monthly sales report entry / (01/01/23) / BLANK / MONTHLY

If today's date is (06/06/23), then I would like to have the following:

ID REQUEST / REQUEST NAME / START DATE / CANCELATION DATE / RECURRENCE / DATE PERFORMED

001 / Monthly sales report entry / (01/01/23) / BLANK / MONTHLY / (01/01/23)
001 / Monthly sales report entry / (01/01/23) /BLANK / MONTHLY / (02/01/23)
001 / Monthly sales report entry / (01/01/23) / BLANK / MONTHLY / (03/01/23)
001 / Monthly sales report entry / (01/01/23) / BLANK / MONTHLY / (04/01/23)
001 / Monthly sales report entry / (01/01/23) / BLANK / MONTHLY / (05/01/23)
001 / Monthly sales report entry / (01/01/23) / BLANK / MONTHLY / (06/01/23)

Nota

LINK EXAMPLE DATA:  DATA 

Thank you in advance for your assistance.

Best regards,

[lbendlin]

Read about the suite of GENERATE functions in DAX.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[AmauryC_]

Hi bro,

thanks for reply, i just put a link with a example data, in the previus post.

this: DATA 

thanks

[lbendlin]

Thank you for providing the sample data. 
Please show the expected outcome based on the sample data you provided.