Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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!

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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!