Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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

 

 

 

 

 

 

 

 

 

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

Need Help
Tips and Tricks

3 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    HI Arjun Anonymous

     

    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 )