Forum Discussion

Matt22365's avatar
Matt22365
Resolver III
9 years ago
Solved

Adding Column from one powerpivot table to another from Project Online Odata

Hi   I hope you can help, I am new to power pivot so forgive me if this is really easy.   I am trying to create a capacity graph for my department from Odata derived from Microsoft Project Online...
Need Help
  • Matt22365's avatar
    Matt22365
    9 years ago

    Hi

     

    I think I have managed to sort this, all I needed to do was to create a new table with just the TimeByDay and create a relationship between both resource tables and this new Timeset table.

     

    Now I just need to figure out why my teams capacities finish mid 2017

     

    Thanks for your help

     

    Matt

Matt22365's avatar
Matt22365
Resolver III
9 years ago

Hi v-ljerr-msft

 

Thank you for getting back to me. Unfortunately our company wont allow me to put the actual document online due to it having personel details about the resources built into it. However I can you screen shots with the names blanked out.

 

Below - Top table is a combined table with resource demand (using the timebyday (w/c) from resource demand with the capacity from another table added in. As you can see the capacity is only giving 330. The table beneath it shows capacity with the timebyday(w/c) from its own table and this gives the correct number i.e. 37.5 per week.

I cannot seem to make the combined table show this breakdown correctly.

 

This is the way I currently have it set up in power pivot. This links reource name between both Resourcetimephased and ResourceDemand (these were connected automatically).

Thank you for your help

 

Matt

Matt22365's avatar
Matt22365
Resolver III
9 years ago

Hi

 

I think I have managed to sort this, all I needed to do was to create a new table with just the TimeByDay and create a relationship between both resource tables and this new Timeset table.

 

Now I just need to figure out why my teams capacities finish mid 2017

 

Thanks for your help

 

Matt

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi Matt22365,

     

    Great to hear the problem got resolved! Could you accept your reply as solution to help others who may have similar issue easily find the answer and close this thread?:smileyhappy:

     

    Regards