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...
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.