cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
freiburgc Regular Visitor
Regular Visitor

Dynamic BOM

Hello everybody,

 

I need your help again.

 

I want to create a dynamic BOM based on sales articels.

 

The solution should look like this:

 

 

Bom_Zielbild.png

The articels are structured in 2 different levels:

 

Production_Structure.png

On top is the articel that are sold, then the finished produced articel and on bottom the individual materials.

 

I want to choose the sales articel and then see which materials are used to produce them and the quantity.

 

I have three different tables: Calendar, Item table (unique entries) and Item Ledger Entry Tabel (contains all consumtpion and output for every article and materials).

 

Sorry for the short description of my problem. I am not sure if I should write more to explain my problem. If I explained something not clear enough or your missing information, please say something!

 

I am working on that for 4 days now and I don´t get close to the solution I need and I am thankfull for every hint or solution I can get!!

 

Thank you very much!

Christian

5 REPLIES 5
freiburgc Regular Visitor
Regular Visitor
Community Support Team
Community Support Team

Re: Dynamic BOM

@freiburgc ,

 

You may modify BOM measure as pattern below:

BOMListe =
CALCULATE (
    SUM ( Tab_Item_Ledger_Entry[Quantity] ),
    FILTER ( Tab_ITEM, Tab_ITEM[Verkauf] > 0 ),
    FILTER (
        Tab_Item_Ledger_Entry,
        Tab_Item_Ledger_Entry[Document No] IN VALUES ( Tab_ITEM[No] )
            && Tab_Item_Ledger_Entry[Posting Date] IN VALUES ( Tab_Date[Date] )
    )
)

Community Support Team _ Jimmy Tao

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

freiburgc Regular Visitor
Regular Visitor

Re: Dynamic BOM

Hello @v-yuta-msft ,

 

thank your for your help, but unfortunately the measure doesn´t work.

 

Do you have another idea how to make it work?

The measure I tried to use:

 

 

BOM = CALCULATE(
SUM(Tab_Item_Ledger_Entry[Quantity]);
   FILTER(Tab_ITEM;Tab_ITEM[Sales Articles]="YES");
     FILTER(Tab_Item_Ledger_Entry;
Tab_Item_Ledger_Entry[Document No] IN VALUES(Tab_Item_Ledger_Entry[Item No_])
&& Tab_Item_Ledger_Entry[Posting Date] IN VALUES(Tab_Date[Date])))

The data model I use:

Model.PNG

 

Maybe you have another idea how to solve my problem. I am open to every solution!

 

Thank you for your support!

Christian

 

Community Support Team
Community Support Team

Re: Dynamic BOM

@freiburgc ,

 

Still not quite clear about your requirement. Could you share more details about your expected result?

 

Community Support Team _ Jimmy Tao

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

freiburgc Regular Visitor
Regular Visitor

Re: Dynamic BOM

@v-yuta-msft,

 

i want to create a structure which is based on the sales article.

 

Bom_Zielbild.pngI have a slicer to choose my sales article, e.g. Item: 1000.000 Red Car then I want to have a bill of material  in a table with all the production articles which are need to produce the Red Car. As you can see in the picture above.

The BOM is basd on the selection of the slicer. The values in the slicer are text type, not a number.

The Data model is the same as I posted in my first post.

 

I am so sorry for bad explanation, i hope could make my goal more clear.

 

Thank your for your suppport!

cfeiburg