Forum Discussion

SoColdOutside's avatar
SoColdOutside
New Member
3 years ago

Creating a BOM Drill Down

Hi All,   I am fairly new to PowerBI, and what I'm trying to do is create a tool in BI that allows me to filter by an item number, and have it return all BOM's that the ingredient goes into. Sounds...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  SoColdOutside ,

I created some data:

 

Here are the steps you can follow：

1. Create calculated column.

Flag =
 CONCATENATEX(FILTER(ALL('Table'),
 'Table'[child]=EARLIER('Table'[child])),[parents],",")

2. Result:

If it does not meet your expectations, can you express the expected results in the form of pictures, we can better help you.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly