Forum Discussion

Matt22365's avatar
Matt22365
Icon for Resolver III rankResolver 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
Icon for Resolver III rankResolver 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
Icon for Microsoft Employee rankMicrosoft 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