Forum Discussion
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...
hi, please find the link to sample file
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?
adjusted the data model, combined the tables as you suggested , atatched the revised file, can you tell me how do i proceed now?