Forum Discussion
Solved
Product Structure and Power BI
Good day all, I'm trying to create a visual to display product structure and some general information on that product. The information is pulled from one master stock on hand report, this report ...
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,
Using the Query Editor, ensure that you fill the blanks in the first column with Product Numbers. Assuming the first column in your second image is the product, build a relationship from the first column of the first table to the first column of the second table. To your visual, drag both columns from the second table and then write this measure
=SUM(Data[ONHANDBAL])
Hope this helps.