Power query cross allocation

Hi Anonymous ,

What's your final allocation?

Please show me your expected results.

Below is your raw data, right?

Below the "Final Allocation" field is your expected result, right?

Please tell me what the corresponding expected result is, and the calculation logic.

Best Regards,

Stephen Tao

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

Dear Stephen, thx for your reply. The logic is, take A allocation to C for example, firstly A allocate 20% to B, and 80% to C, secondly, B allocate 50% to C, so final A to C is 80%*A + 20%*50%*A = 90%.