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.
Solved! Go to Solution.
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 )
Thank you @Zubair_Muhammad,
How can I use this function by importing the file from other workbook, which calaculation do i need to select?