Help with creating new Rows from previous rows in same table

[Rate]

Hello!

I am having trouble with generating new rows in my table. I have a table with a line for each product we are selling (Bread, Milk and Salt). As the Bread comes with a gift, I would want to generate a new row for every Bread sold, replicating the same information as in the said row, but changing the product sold (Gift in this case).

Original Table:

questionnarie_response_line_id	gift_product_id	gift_product_name	gift_product_qty	created
822	2	Bread	10	17/06/2019 9:04
943	2	Bread	10	17/06/2019 10:22
1397	2	Bread	3	18/06/2019 9:42
1389	6	Milk	5	18/06/2019 9:37
659	6	Milk	28	14/06/2019 17:15
352	5	Salt	18	14/06/2019 9:14
383	5	Salt	5	14/06/2019 9:41

Desired table:

questionnarie_response_line_id	gift_product_id	gift_product_name	gift_product_qty	created
822	2	Bread	10	17/06/2019 9:04
943	2	Bread	10	17/06/2019 10:22
1397	2	Bread	3	18/06/2019 9:42
1389	6	Milk	5	18/06/2019 9:37
659	6	Milk	28	14/06/2019 17:15
352	5	Salt	18	14/06/2019 9:14
383	5	Salt	5	14/06/2019 9:41
822	99	Gift	10	17/06/2019 9:04
943	99	GIft	10	17/06/2019 10:22
1397	99	Gift	3	18/06/2019 9:42

Do you have any idea as to how I could achieve this?

Thanks a lot!

[jdbuchanan71 · Accepted solution]

Hello @Rate 

Give this a try

Union Table = 
UNION(
    SUMMARIZE('Table','Table'[questionnarie_response_line_id],'Table'[gift_product_qty],'Table'[created],'Table'[gift_product_id],'Table'[gift_product_name]),
    SUMMARIZE(
        CALCULATETABLE(
            'Table',
            'Table'[gift_product_name] = "Bread"
        ),
        'Table'[questionnarie_response_line_id],
        'Table'[gift_product_qty],
        'Table'[created],
        "gift_product_id",VALUE("99"),
        "gift_product_name","Gift"
    )
)

[Rate]

Hello @jdbuchanan71 

Wow, just WOW. Thanks so much. That worked like a Charm!

Really grateful!! You just made my day.

Thanks a lot and have an amazing day.