Can anyone offer insight on how to successfully create a power BI report based on resource time sheet entries? I have been able to create only based on the current timesheet, but would like the functionality to select archived Timesheets and display entry details.
The attached image is the layout I am looking for - in this example, the current timesheet for one resource is being displayed as that is the only resource using TS in this demo. Ideally, as more resources have timesheets, there will be more columns with the viewer able to filter by TS ending date (Primarily Archived or both current and archived if possible)

Report
All responses (
Answers (