Filtering nested entries in data

[Anonymous]

Hello,

I've been tasked by my company to create a system that will find all part data for a specific assembly. I have a giant table of data, and I have two main pieces of data. I have a column I've called "ALL PARTS" and another called "ALL PARENTS". ALL PARTS consists of every part that we have produced. ALL PARENTS consists of groupings of thse parts. However, we might have an assembly within an assembly within an assembly. In that case, an assembly will be listed as a part, with it's parent assembly listed. I've included a screenshot below of a sample of my data.

So what I'm trying to do is create a system that will allow a user to type in any Part number, and filter down the list to that part number and any parts/assemblies (and any parts nested within said assemblies) nested within it. I created one system that pulled all Parts for a parent, then applied that list as a filter on a second table, but it took ages to compute and was not feasible for use. It also only searched through the first level of the assembly, and I need it to follow the heirarchy to it's full extent.

My current idea is to create a custom column to sort of track the heirarchy of parts in an assembly by taking the Parent and adding a number afterwards representing its heirarchy. Then I could simply filter the table to only include Parts with a Tracker that included PART_XXXXXX 1 or something.

Let me know if more infromation is required, I'm very new to power query, specifically new to coding in M.

[v-xicai]

Hi @Anonymous ,

I am not sure what desired result would you want, could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Please read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Amy