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!
I would use the group function from the GUI, grouping on Month Name and WC, and choose the Sum aggregation on Available Capacity on the o e table, and do the same type on the other table, but sum the Required capacity. Then you can Join the two tables on the Month Name and WC fields. Then you can use the Pivot functions to transform it all into the columns you want to see.
--Nate