Address the Component status as a Parent or a child depending on Hierarchy Path

Question

I have a BOM and want to set&nbsp; a Parent or a child status due to position in a Hierarchie Path:LevelCompParentImm ParentHiarchyParent101101&nbsp;10111002101101101|1002.210081011002101|1002|100811003101101101|1003.210091011003101|1003|1009.210081011003101|1003|100811010101101101|101011004101101101|1004.210111011004101|1004|1011.210051011004101|1004|1005..310121011005101|1004|1005|1012..310131011005101|1004|1005|1013.210051011004101|1004|1005..310071011005101|1004|1005|1007...410141011007101|1004|1005|1007|1014...410151011007101|1004|1005|1007|1015...410161011007101|1004|1005|1007|1016...410171011007101|1004|1005|1007|1017..310181011005101|1004|1005|1018..310191011005101|1004|1005|1019..310201011005101|1004|1005|102011021101101101|1021&nbsp;I want to address the Component status as this :&nbsp;LevelCompParentImm ParentHiarchyComp StatusParent101101&nbsp;101Parent11002101101101|1002Parent.210081011002101|1002|1008Child11003101101101|1003Parent.210091011003101|1003|1009Child.210081011003101|1003|1008Child11010101101101|1010Child11004101101101|1004Parent.210111011004101|1004|1011Child.210051011004101|1004|1005Parent..310121011005101|1004|1005|1012Child..310131011005101|1004|1005|1013Child.210051011004101|1004|1005Parent..310071011005101|1004|1005|1007Parent...410141011007101|1004|1005|1007|1014Child...410151011007101|1004|1005|1007|1015Child...410161011007101|1004|1005|1007|1016Child...410171011007101|1004|1005|1007|1017Child..310181011005101|1004|1005|1018Child..310191011005101|1004|1005|1019Child..310201011005101|1004|1005|1020Child11021101101101|1021Child

oleander · Accepted Answer

Sorry , I didn't see it myself:"=if(BOM[Level]="Parent";"Parent";IF(CONTAINS(BOM;BOM[Imm&nbsp;Parent];BOM[Comp]);"Parent";"Child"))"

Forum Discussion

Address the Component status as a Parent or a child depending on Hierarchy Path

1 Reply

Related content

Date hierarchy

Circular dependency

Matrix component - order question

Dax query dependency

reusable components in reports

Level	Comp	Parent	Imm Parent	Hiarchy
Parent	101	101		101
1	1002	101	101	101\|1002
.2	1008	101	1002	101\|1002\|1008
1	1003	101	101	101\|1003
.2	1009	101	1003	101\|1003\|1009
.2	1008	101	1003	101\|1003\|1008
1	1010	101	101	101\|1010
1	1004	101	101	101\|1004
.2	1011	101	1004	101\|1004\|1011
.2	1005	101	1004	101\|1004\|1005
..3	1012	101	1005	101\|1004\|1005\|1012
..3	1013	101	1005	101\|1004\|1005\|1013
.2	1005	101	1004	101\|1004\|1005
..3	1007	101	1005	101\|1004\|1005\|1007
...4	1014	101	1007	101\|1004\|1005\|1007\|1014
...4	1015	101	1007	101\|1004\|1005\|1007\|1015
...4	1016	101	1007	101\|1004\|1005\|1007\|1016
...4	1017	101	1007	101\|1004\|1005\|1007\|1017
..3	1018	101	1005	101\|1004\|1005\|1018
..3	1019	101	1005	101\|1004\|1005\|1019
..3	1020	101	1005	101\|1004\|1005\|1020
1	1021	101	101	101\|1021