cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rate Regular Visitor
Regular Visitor

Help with creating new Rows from previous rows in same table

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_idgift_product_idgift_product_namegift_product_qtycreated
8222Bread1017/06/2019 9:04
9432Bread1017/06/2019 10:22
13972Bread318/06/2019 9:42
13896Milk518/06/2019 9:37
6596Milk2814/06/2019 17:15
3525Salt1814/06/2019 9:14
3835Salt514/06/2019 9:41

 

Desired table:

questionnarie_response_line_idgift_product_idgift_product_namegift_product_qtycreated
8222Bread1017/06/2019 9:04
9432Bread1017/06/2019 10:22
13972Bread318/06/2019 9:42
13896Milk518/06/2019 9:37
6596Milk2814/06/2019 17:15
3525Salt1814/06/2019 9:14
3835Salt514/06/2019 9:41
82299Gift1017/06/2019 9:04
94399GIft1017/06/2019 10:22
139799Gift318/06/2019 9:42

 

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

 

Thanks a lot!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Help with creating new Rows from previous rows in same table

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"
    )
)
2 REPLIES 2
Highlighted
Super User
Super User

Re: Help with creating new Rows from previous rows in same table

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 Regular Visitor
Regular Visitor

Re: Help with creating new Rows from previous rows in same table

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.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 260 members 3,025 guests
Please welcome our newest community members: