Forum Discussion
Power query cross allocation
I have a table like this: Department Other Department Allocation A B 20% A C 80% B A 50% B C 50% C A 40% C B 60% How can I calculate the final allocation perce...
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%.