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...
Need Help
Tips and Tricks
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity 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 )