Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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:

 

 

The articels are structured in 2 different levels:

 

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

Need Help

5 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Anonymous ,

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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:

       

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

       

      Thank you for your support!

      Christian

       

      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        7 years ago

        Anonymous ,

         

        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.