Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Prorate values considering dates order.

Hello everybody, I need your help, I need to prorate values considering dates. I have a production table (quantities to be produced) by items on different dates. I have a table per item and exces...
Need Help
Tips and Tricks
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi Anonymous ,

 

I did a test and refer to the following results.

M1 = IF(MAX('Table'[Initial Excess])>=MAX('Table'[Req. Qty]),0,MAX('Table'[Req. Qty])-MAX('Table'[Initial Excess]))
M2 = IF(MAX('Table'[Initial Excess])>=MAX('Table'[Req. Qty]),MAX('Table'[Initial Excess])-MAX('Table'[Req. Qty]),0)

 

If it is not what you need, can you provide detailed instructions and screenshots of the expected results, I will answer you as soon as possible.


Let me know the result immediately, looking forward to your reply.

Best Regards,
Henry

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
    5 years ago

    Thank you,

     

    I am sorry, I do not have the initial excess in the first table, since it is calculated according to what is covering the required amount.