cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Arjun926 Frequent Visitor
Frequent Visitor

Create duplicate Rows referring above row and change the values in duplicated row

Hello Expert,

 

I'm newbie to power query and PBI as trying to find solution for my requirement and afraid as i couldn't find it.

Here is input

 

 

Input.JPG

 

 

 

 

 

 

 

Firstly, it should create duplicate row referring the upper row and Duplicate row should calcuclate by adding D+G columns of Input.

Ex for 1 - in column D as 16 and G as 8 = 24 should appear in new dulicate line item.

 

Appreciate your valuable inputs in this regard.

 

Regards,

Arjun

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Create duplicate Rows referring above row and change the values in duplicated row

@Arjun926

 

Please see attached file as well

 

createdupl.png

3 REPLIES 3
Super User
Super User

Re: Create duplicate Rows referring above row and change the values in duplicated row

HI Arjun @Arjun926

 

You can also do it via DAX calculated TABLE

 

Go to Modelling Tab>> NEW TABLE

 

Table =
VAR temp =
    SELECTCOLUMNS (
        table1,
        "A", [A],
        "B", [B],
        "C", [C],
        "D", [D],
        "E", [E],
        "F", [D] + [G],
        "G", [F] + [I],
        "I", [I]
    )
RETURN
    UNION ( Table1, temp )
Super User
Super User

Re: Create duplicate Rows referring above row and change the values in duplicated row

@Arjun926

 

Please see attached file as well

 

createdupl.png

Arjun926 Frequent Visitor
Frequent Visitor

Re: Create duplicate Rows referring above row and change the values in duplicated row

Thank you @Zubair_Muhammad

 

How can I use this function by importing the file from other workbook, which calaculation do i need to select?

 

Regards,

Arjun