Forum Discussion
Product Structure and Power BI
Good day all,
Just wanna give an update to this issue, I have managed to get it resolved, fixing up relationships and creating an index for the BOM data and playing with some of the filters 🙂 all in all good result its what I was looking for.
Once again thank you all for your input as it all did help
Regards
Snowy
Hi Snowy34 ,
Sorry for that, We cannot understand your data model clearly, Could you please provide a sample mockup table based on fake data or describle the fields of each tables and the relations between tables simply? Please don't have any Confidential Information or Real data in your reply.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Good day v-lid-msft
Attached is a sheet that you could use as TEST DATA
Tab BOM is my BOMS structure, for example, BOM 6611 has 5 components that makeup 6611 items.
Tab SoH is my stock on hand report for all of my warehouses, this report holds the BOM code 6611 and all 5 components.
Now I require two slicers, one of the slicers is the WH number as a drop-down that is simple. The second one is the BOM's, the user will select the BOM he will like to check stock on hand for. Something like the below screenshot.
Thank you again for helping out.
Hi,
In the second table (SoH), I am confused with the content of the first column. That column seems to contain data from the first 2 columns of the first table (BOM).
Good day Ashish_Mathur
The Stock On Hand report will have the finished code aka the BOM code and the components for that BOM.
The idea is the user can check to see his stock on the finished product aka the BOM and she/he can also check components to create a manufacturing order if required.
Good day all,
Just wanna give an update to this issue, I have managed to get it resolved, fixing up relationships and creating an index for the BOM data and playing with some of the filters 🙂 all in all good result its what I was looking for.
Once again thank you all for your input as it all did help
Regards
Snowy
