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 got the grouping bit, it looks like this:
Table 1 (Available):
Table 2 (required)
Got issues with joining. If I choose to merge queries, I can choose 2 tables. I choose table 1 and table 2. Then click on the column that is the same in both (month). I can't seem to select both month and wc.
Hold the CTRL key when selecting your second set of columns.
--Nate