Forum Discussion
Adding column from another table based on certain criteria
Hi all, I am looking to make a new summary table in excel power query (showing the available capacity and required capacity per wc per month), containing columns from other tables based on certain c...
I worked it out with a pivot in excel via power pivot. It's now showing as needed and I get it to automatically update as it's done by power pivot.
Thanks heaps!
Hi Nate,
Thanks heaps, I got now got both columns selected and if I merge I get this:
The left join seems to make more sense than the inner, as the inner has less rows.
As I now have a table on the right, what do I do next?
I think I need to do sum, then I get:
Then I get:
How do I pivot to get the final result?
Is it correct that I have to pivot outside of power query, in excel itself? Or is there a way to do it in power query?