Forum Discussion

helen_wrensted1's avatar
helen_wrensted1
Advocate II
4 months ago
Solved

Create new table

Hi.   I have a table with bill of materials for all our products, below example of 2 products:   Looking at main number 5663, it includes raw materials and another BOM, Sub number 5664, mar...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    3 months ago

    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.

ryan_mayu's avatar
ryan_mayu
Super User
4 months ago

helen_wrensted1 

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 assembly
 
pls see the attachment below
 
helen_wrensted1's avatar
helen_wrensted1
Advocate II
4 months ago

ryan_mayu 

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...

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 months ago

    helen_wrensted1 

    Now I totally understand your requirement.

     

    You can do the data transfer and create the new table in Power query

     

    pls see the attachment below