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 ,

 

foodd , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is the sample data:

 

 

You can try below formula to create a measure:

Need to buy = SUMX (

    'Table',

    IF (

        'Table'[Amount] > 'Table'[Consumption],

        0,

        'Table'[Consumption] - 'Table'[Amount]

    )

)

 

The final result is shown in the figure:

 

If you have any other questions please feel free to contact me.

 

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

Hello Anonymous Thank you for your reply. There is a relationship between first table's first column and second table's first column and icant break it because it affects rest of document. So, is there any other solution for this?

Thanks in advance 🙏🙏