Forum Discussion

ChirSidh's avatar
ChirSidh
Icon for Helper II rankHelper II
2 years ago

Regionwise Allocation vs Available hours

in my power bi matrix table , i have employee in rows, allocation hours in columns, columns examples are North, South, East, West and total column. I have a available hours column as well. But the av...
Need Help
  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    I slightly rearranged your data model to understand it better.  

     

    Looking at this you can streamline by combining the Calendar and Holiday tables, and the Res Details table with the EmployeeOfficeLookup and TBL_New Resources.  I'm a little baffled by the Tbl_New Weeks table.  That should go into the calendar too, no?

    • ChirSidh's avatar
      ChirSidh
      Icon for Helper II rankHelper II
      2 years ago

      adjusted the data model, combined the tables as you suggested , atatched the revised file, can you tell me how do i proceed now?

       https://we.tl/t-paNqGPfMlY