studioacosta
New Member
- Joined
- Jan 17, 2025
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
I'm working with an existing timesheet (that I can modify to a slight degree). The end goal is to be able to create project reports in power bi that break down time spent by each employee per phase of the project across time. I've gotten to the point where I've created a power query to clean up the data and trim it down to only the specific project I'm looking at. Now I've got a table with the first column being the date, and each subsequent column showing the different phases, and the cell values populating for time worked (Right now I'm just working with one time sheet for one person).
I think I need this to be a pivot table though, and I can't figure out how to make that happen. If I select the current table and make it a pivot table, "hours worked" is not a field option, and I don't know how to get excel to recognize it as one with the table format that I have. Can anyone help me sort through this mess? Uploading screenshots of: the starting timesheet, the table I've created using power query, and the structure of the visual I'm hoping to arrive at eventually.
I think I need this to be a pivot table though, and I can't figure out how to make that happen. If I select the current table and make it a pivot table, "hours worked" is not a field option, and I don't know how to get excel to recognize it as one with the table format that I have. Can anyone help me sort through this mess? Uploading screenshots of: the starting timesheet, the table I've created using power query, and the structure of the visual I'm hoping to arrive at eventually.