Forum Discussion

Rate's avatar
Rate
Helper III
7 years ago
Solved

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!

Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    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

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    7 years ago

    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's avatar
      Rate
      Helper III
      7 years ago

      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.