Forum Discussion
Create new table
Hi helen_wrensted1,
We are following up to inquire whether your issue has been resolved. If it has been resolved, we would be grateful if you could share the solution with the community, as it may help others facing similar challenges.
However, if the issue remains unresolved and you have any further queries related to it, please share either a simplified or a sanitized PBIX file. Alternatively, you may provide the data model diagram from the Relationships view, along with a small sample dataset containing 2 to 3 rows for all tables.
Please ensure the data is relevant and clearly demonstrates your issue or query in a structured format (not as an image), and that it is free from any sensitive information. Also, please include the expected outcome based on the provided data.
Thank you.
the first one row does not display.
in the visual filter, unselect assembly.
for the 2nd question. why replace last 6 rows to 5664. The rest rows may have the same name ,sub num ,etc. What's the logic to pick out these 6 rows? could you pls clarify?
My wish is to have a full list (and costs) of main number 5663.
5663 contains raw materials and also a bill of material 5664. I would like to see the components of the BOM for 5664, so I have a list of all raw materials included in 5663 and they should som up to 3.814,81
you can create a column
Column =var _num=maxx(FILTER('BOM details new','BOM details new'[Sub number]=EARLIER('BOM details new'[Main number])),'BOM details new'[Main number])return if(ISBLANK(_num),'BOM details new'[Main number],_num)select 5663 in the column that we created and unselect assemblypls see the attachment belowNow I totally understand your requirement.
You can do the data transfer and create the new table in Power query
pls see the attachment below
Thanks a lot for your effort - it is highly appreciated.
It works great for number 5663, but BOM 5664 is also included in 5661 and 5662. In order to allocate the 5664 expenses to all relevant main numbers, I think it will be necessary to create a new table with added rows...