Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

@Anonymous

 

Please see attached file as well

 

createdupl.png


Regards
Zubair

Please try my custom visuals

View solution in original post

3 REPLIES 3
Zubair_Muhammad
Community Champion
Community Champion

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 )

Regards
Zubair

Please try my custom visuals

@Anonymous

 

Please see attached file as well

 

createdupl.png


Regards
Zubair

Please try my custom visuals
Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.