Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

data relationships

I have two different tabs on excel. One has employees and amount of hours worked per employee. Another has phases of a project and the amount of hours in each phase as well as the total number of hours. How can I relate the amount of hours each employee worked to the total number of hours worked on the project as a whole in Power BI?

12 Replies

  • NipponSahore's avatar
    NipponSahore
    Resolver II
    8 years ago

    Can you please share what your data looks like. Maybe a sample might help

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        The "Actual Work" column in the first photo is the same amount of hours as the "Total Work" column in the second photo (with the employee data)

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Yes, as NipponSahore mentioned please post the sample data set along with the expected result.

     

    Thanks
    Raj