Forum Discussion

yavuzonaran's avatar
yavuzonaran
Frequent Visitor
2 years ago

Production planning practice

Hello,   I want to calculate yellow areas in the table could anyone help me?    
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi yavuzonaran ,

I apologize for my late reply. Thank you very much for your reply. Following your description, I recreated the two tables that are related:

 

 

 

The relationship between them is:

 

 

Here is my solution:

 

1.Create two measures:

 

 

 

Production Plan = MAX('Table'[Production Plan1])

Consumption = INT(MAX('Table'[Amount])*'Table'[Production Plan])

 

 

 

 

2. You can try below formula to create the measure “need to buy”:

 

 

 

Need to Buy = SUMX('Table (2)',IF('Table (2)'[Amount]<'Table'[Consumption],'Table'[Consumption]-'Table (2)'[Amount],0))

 

 

 

3.The final result is as follows:

 

 

Best Regards,
Zhu
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

 

yavuzonaran's avatar
yavuzonaran
Frequent Visitor
2 years ago
Hi Anonymous Thank you very much for your detailed answer appreciate that 🙏 I want to ask you something, In my original workbook, I already have relationship between two tables which are Table 1 [Product Code] and Table 2 [Raw Material Code]. And I cant change this because affecting rest of workbook. If it's possible for you, i would like to show you on an online meeting shortly (max 5 min) and we can reach solution. Hope to hear from you soon 🙏
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi yavuzonaran ,

     

    Unfortunately I can only offer you help on the community. But according to your description, I made changes to the model relationships I created and now I have the situation as shown in the picture:

     

     

    Is this a problem that you are experiencing? I would be grateful if you could provide me with the pbix file or sample data. Remember to remove sensitive data and do not log in to your account in Power BI Desktop when uploading the pbix file.

     

    Best Regards,
    Zhu
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!