The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 |
Solved! Go to Solution.
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 column
Create custom hierarchy
Create matrix visual
Notice: I add visual level filter to remove blank value.
Regards,
Xiaoxin Sheng
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 column
Create custom hierarchy
Create matrix visual
Notice: I add visual level filter to remove blank value.
Regards,
Xiaoxin Sheng
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |