Forum Discussion
Parent / Child Relation + Multiply
Hi !
Ive the following table.
Ive succeeded with Power BI to sum for A (=B+F) and B(=C+D+E) through a parent / child relationship.
Nevertheless, i wd like to add a mark-up on A and B meaning B = (C+D+E)*1,07 and A =(B+F)*1,07.
Any suggestion would be highly appreciated :)
Many thanks
| ITEM | PathID | Level of Current Element | Type | Current Element | Current Element Issue Index | Parent Element | Parent Type | Parent Issue Index | Quantity (link only) | Designation | Unit Price |
| A | D57248000004 | 0 | DASSY | D57248000004 | AS | NULL | DASSY | NULL | NULL | WING BOX STRUCTURE GA | |
| B | D57248000004 / D57248006010 | 1 | DASSY | D57248006010 | M | D57248000004 | DASSY | AS | 1.0000000 | BOLTING PNL 1 FS BTM | |
| C | D57248000004 / D57248006010 / ABS0548VHK4-06 | 2 | STDPT | ABS0548VHK4-06 | NULL | D57248006010 | DASSY | M | 25.0000000 | PIN,SWAGELOCKINGCSK | 50 |
| D | D57248000004 / D57248006010 / ASNA2025-4 | 2 | STDPT | ASNA2025-4 | NULL | D57248006010 | DASSY | M | 220.0000000 | COLLAR,SWAGELOCKING | 100 |
| E | D57248000004 / D57248006010 / D57250208216 | 2 | DDPT | D57250208216 | L03 | D57248006010 | DASSY | M | 2.0000000 | PLUG SEALING | 1000 |
| F | D57248000004 / ABS0548VHK6-12 | 1 | STDPT | ABS0548VHK6-12 | NULL | D57248000004 | DASSY | M | 7.0000000 | PIN,SWAGELOCKINGCSK | 3000 |
HI mg,
I'd like to suggest you take a look at below link which mentioned about how to use path function to create custom hierarchy for analysis.
Sample:
Level 1 = VAR replaced = SUBSTITUTE ( [PathID], " ", "" ) RETURN PATHITEM ( SUBSTITUTE ( replaced, "/", "|" ), 1 ) Level 2 = VAR replaced = SUBSTITUTE ( [PathID], " ", "" ) RETURN PATHITEM ( SUBSTITUTE ( replaced, "/", "|" ), 2 ) Level 3 = VAR replaced = SUBSTITUTE ( [PathID], " ", "" ) RETURN PATHITEM ( SUBSTITUTE ( replaced, "/", "|" ), 3 )Add hierarchy columnCreate custom hierarchyCreate matrix visual
Notice: I add visual level filter to remove blank value.
Regards,
Xiaoxin Sheng
1 Reply
HI mg,
I'd like to suggest you take a look at below link which mentioned about how to use path function to create custom hierarchy for analysis.
Sample:
Level 1 = VAR replaced = SUBSTITUTE ( [PathID], " ", "" ) RETURN PATHITEM ( SUBSTITUTE ( replaced, "/", "|" ), 1 ) Level 2 = VAR replaced = SUBSTITUTE ( [PathID], " ", "" ) RETURN PATHITEM ( SUBSTITUTE ( replaced, "/", "|" ), 2 ) Level 3 = VAR replaced = SUBSTITUTE ( [PathID], " ", "" ) RETURN PATHITEM ( SUBSTITUTE ( replaced, "/", "|" ), 3 )Add hierarchy columnCreate custom hierarchyCreate matrix visual
Notice: I add visual level filter to remove blank value.
Regards,
Xiaoxin Sheng