https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-identify-the-parent-of-a-value-in-the-same-row/m-p/2411076#M63517 <P>Anonymous</LI-USER> , Try a new column like</P> <P>&nbsp;</P> <P>Switch(True() ,<BR />isblank(Table[Level4]) &amp;&amp; not(isblank(Table[Level3])) &amp;&amp; not(isblank(Table[Level2])) , Table[Level 2],<BR />not(isblank(Table[Level4])) &amp;&amp; not(isblank(Table[Level3])) , Table[Level 3],<BR />[Level 1]<BR />)</P> Wed, 23 Mar 2022 03:57:32 GMT amitchandak 2022-03-23T03:57:32Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-identify-the-parent-of-a-value-in-the-same-row/m-p/2410402#M63484 <P>In this example table you can see that there are 4 levels. I am trying to create a column where I can fnid the parent value of a value. For example in the first row, in level three the value is "R98300" and its parent is in level 2 whose value is "R8155C" The column I create will have a row for each iteration throughout the Levels. It goes from higher levels to lower levels. Thanks!</P><P><img /></P><P>&nbsp;</P> Tue, 22 Mar 2022 18:39:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-identify-the-parent-of-a-value-in-the-same-row/m-p/2410402#M63484 Anonymous 2022-03-22T18:39:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-identify-the-parent-of-a-value-in-the-same-row/m-p/2411076#M63517 <P>Anonymous</LI-USER> , Try a new column like</P> <P>&nbsp;</P> <P>Switch(True() ,<BR />isblank(Table[Level4]) &amp;&amp; not(isblank(Table[Level3])) &amp;&amp; not(isblank(Table[Level2])) , Table[Level 2],<BR />not(isblank(Table[Level4])) &amp;&amp; not(isblank(Table[Level3])) , Table[Level 3],<BR />[Level 1]<BR />)</P> Wed, 23 Mar 2022 03:57:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-identify-the-parent-of-a-value-in-the-same-row/m-p/2411076#M63517 amitchandak 2022-03-23T03:57:32Z